Home / server / Questions

Questions[oracle9i](server)

Martin Hope
Oh Chin Boon
Asked: 2011-04-29 18:32:28 +0800 CST
  • 2

I would like to know how usually one would delete data from an Oracle 9i DBMS which actually frees up disc space. Past scenario, we have had cases where clearing up 1-2 million rows of data does not translate to a decrement in disc space usage.

Scenario:

sqlplus > delete from audit_log where date_created between today and the day before;

sqlplus > 2 million records deleted.

bash$: du -sh (after issuing the delete above)

Results in no change to the disc space usage.

Which also brings me to the question, will one need to flush anymore tables in order for oracle to completely delete all the data that is supposedly deleted by the delete DML

oracle oracle9i
Martin Hope
AJM
Asked: 2011-01-07 06:16:36 +0800 CST
  • 2

I have an oracle 9 database. There is a requirement to move this to Oracle 11.

What is the best way to achieve this. Is it enough to export the database on 9 and import it again on 11 or is there an upgrade process that can be gone through?

oracle oracle-11g oracle9i
Martin Hope
wurlog
Asked: 2010-10-22 06:02:15 +0800 CST
  • 2

I have here a database which should be quiet small. There should be around 350.000 lines of textonly data but the rdbms folder is around 50 GB. Seems way too huge to me.

I found in the rdbms folder a couple of folders (around 60 Mb) and 17.000 files starting with ARC00311.001 until ARC43183.001. The are made every hour und reaching back to 2006.

Are they some kind of logfile?? Regarding backup, should/must I backup these to? Can i delete them? What would be the drawback in doing so?

Thanks

oracle9i