Re: Rollback segments & Transactions

If you are going to populate the table again you can reuse the storage

TRUNCATE TABLE xxx REUSE STORAGE;

otherwise the extents that the table used will be released. Of course, this would also be a good time to size your table and indexes appropriately.

Also note that this implicitly does the same work on your indices.

Rich.

In <4n0ppn$2e7_at_aggedor.rmit.EDU.AU>, orafaq_at_bf.rmit.edu.au (Oracle FAQ) writes:
>Paul Taylor <ptaylor_at_pia.bt.co.uk> writes:
>
>>Hi
 

>>I have the following problem, can anyone help?
 

>>We are trying to delete the contents of a tables, but it is quite large
>>so therefore the rollback segment is either not large enough or I
>>require some additional rollback segments.
>
>What you need to do is TRUNCate the table. This does not go through the
>rollback segments.
>--
>Oracle FAQ and archives maintainer
>orafaq_at_bf.rmit.edu.au (private mail to dtb_at_bf.rmit.edu.au)
>http://www.bf.rmit.edu.au/OracleFAQ ftp://ftp.bf.rmit.edu.au/pub/Oracle/
>http://www.bf.rmit.edu.au/Oracle http://www.bf.rmit.edu.au/~orafaq
>-- NOT TO BE ARCHIVED IN ANY MANNER ON MICROSOFT NETWORK --
Received on Mon May 20 1996 - 00:00:00 CEST