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

Re: Delete a BIG table.

From: Gert Rijs <gem_at_wirehub.nl>
Date: 1997/02/14
Message-ID: <01bc1aa1$87a49ba0$5e5fa5c2@gertrijs>#1/1

Try using the truncate table command

Kenneth Foo <kfo_at_orsil.ubc.ca> wrote in article <5e26gp$7tm$1_at_nntp.ucs.ubc.ca>...
> 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.
Received on Fri Feb 14 1997 - 00:00:00 CST

Original text of this message

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