Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete a BIG table.
Try using 'truncate table <table_name>' to knock off the rows. Hope this is useful.
Ranga Gopalan *** My opinions only, not my employer's *** Stratus Professional and Technical Services,Stratus Computer Inc, Marlboro, MA Email: Ranga_Gopalan_at_stratus.com
Kenneth Foo <kfo_at_orsil.ubc.ca> wrote in article
<5e26gp$7tm$1_at_nntp.ucs.ubc.ca>...
> Hi,
>
> 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