Rollback segments
From: Kochis <djkochis_at_sgi.net>
Date: 1996/12/11
Message-ID: <01bbe786$9e7014c0$79b597ce_at_orion.sgi.net.sgi.net>#1/1
Date: 1996/12/11
Message-ID: <01bbe786$9e7014c0$79b597ce_at_orion.sgi.net.sgi.net>#1/1
[Quoted] [Quoted] Trying to delete all the data from a table (6000 records) [Quoted] I recieved the following:
[Quoted] [Quoted] Ora - 1562: Failed to extend rollback segments (Id=1) [Quoted] [Quoted] Ora - 1682: Max # extents (121) reached for rollback segment add_rb
[Quoted] Did I run out of extents and I need to increase max? Did I run out of space in the rollback segment? (same as above?)
Also,
[Quoted] I have three rollback segments created and online. Oracle always seems to
use the first one i created? Should I point it to a different one?
[Quoted] thanks in advance for any help
newbie
djkochis_at_sgi.net
Received on Wed Dec 11 1996 - 00:00:00 CET