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 -> Delete a BIG table.

Delete a BIG table.

From: Kenneth Foo <kfo_at_orsil.ubc.ca>
Date: 1997/02/14
Message-ID: <5e26gp$7tm$1@nntp.ucs.ubc.ca>#1/1

Hi,

Dose anybody know how to disable the ROLLBACK when you delete a BIG table ( I don't want to drop it) rather than giving you the error message

Unable to extent rollback segment ......

and I hope I can leave the existing rollback segment structure intact because this is only a temporally deleting a big table and I am pretty sure I don't need it to be rollbacked.

Thanks for any help.

Ken
Cheers Received on Fri Feb 14 1997 - 00:00:00 CST

Original text of this message

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