Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to clean-up tablespaces?
Pankaj Asundi wrote in message <36C344AD.5A05263E_at_centurion.flash.net>...
>If you drop all your tables and rebuild them, how do you reclaim back
>the tablespace.
Not sure what you mean as free space is automatically "reclaimed" by Oracle. What you may want to do though is to defrag the tablespace using an ALTER TABLESPACE with the COALESCE option. And it's much safer to use than that DBCC of SQL-Server! :-)
>Also what is the equivalent of dump transaction
>"dbname" with no_log (from MSSQLServer)!
What does this do again? The bad memories of SQL-Server is fading fast since I started working on Oracle a few years ago. :-)
Oh yes.... I think you mean clearing out the transaction log when it gets full? No need in Oracle. If you run out of rollback space you usually need to increase your rollback space or structure the transactions to make them using less rollback space per transaction. Oracle automatically reclaims rollback space. The best is to read up on this subject in the Oracle manuals.
Also, Oracle supports DDL commands that does not require the use of transactions and thus rollback space. For example CREATE TABLE UNRECOVERABLE AS SELECT creates a new table from data from an existing table without transaction processing. Ditto for the UNRECOVERABLE clause for CREATE INDEX. Or loading data into Oracle using the DIRECT load parameter of SQL*Loader.
Hey, what can I say. Welcome to a Real Database (tm)! ;-)
regards,
Billy
Received on Fri Feb 12 1999 - 03:28:38 CST