Re: Rollback segments & Transactions

From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1996/05/21
Message-ID: <Pine.SUN.3.91.960521081347.7444A-100000-100000_at_seatimes>#1/1

However, a TRUNCATE TABLE does not work if there are FK references to the table (even if the FK table is empty!). You need to disable the FKs on the other table and then the TRUNCATE will work. Wish Oracle would check to see if the FK tables were all empty and allow the truncate to proceeed. --Steve

On 20 May 1996, Rich Bernat wrote:

> If you are going to populate the table again you can reuse the storage
>
> TRUNCATE TABLE xxx REUSE STORAGE;
>
> >>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.

+----------------------------------------------------+
| Steve Butler          Voice:  206-464-2998         |
| The Seattle Times       Fax:  206-382-8898         |
| PO Box 70          Internet:  sbut-is_at_seatimes.com |
| Seattle, WA 98111    Packet:  KG7JE_at_N6EQZ.WA       |
+----------------------------------------------------+

All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Tue May 21 1996 - 00:00:00 CEST