Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to clean-up tablespaces?

Re: how to clean-up tablespaces?

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Fri, 12 Feb 1999 11:28:38 +0200
Message-ID: <7a0sco$9m5$1@hermes.is.co.za>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US