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: Having a fast way to drop a 10G bytes tablespace ?

Re: Having a fast way to drop a 10G bytes tablespace ?

From: Dhall0419 <dhall0419_at_aol.com>
Date: 13 Oct 1999 16:58:23 GMT
Message-ID: <19991013125823.14131.00000682@ng-ck1.aol.com>

Use the truncate table command first. It quickly empties the table without creating redo. Then delete the table.
HTH Received on Wed Oct 13 1999 - 11:58:23 CDT

This message: [ Message body ]
Next message: xo55ox_at_hotmail.com: "Extents impact on tablespace size??"
Previous message: Peter Sylvester: "Re: 8i JVM/JServer/Aurora API's"
In reply to: jan1_hk: "Having a fast way to drop a 10G bytes tablespace ?"
Next in thread: Jason Salter: "Re: Having a fast way to drop a 10G bytes tablespace ?"
Reply: Jason Salter: "Re: Having a fast way to drop a 10G bytes tablespace ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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