Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DELETE without loading rollback statements
Message
 
 
To
07/03/2001 13:51:36
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Quebec, Canada
General information
Forum:
Oracle
Category:
Other
Miscellaneous
Thread ID:
00482829
Message ID:
00482928
Views:
15
>Is it possible to do it ? When I try to delete 10 000 rows, Oracle says to me that it is unable to delete, my rollbaks statements are full.
>
>Thank you,
>Christian Cote

Your rolback segment can not handle the deletion of that many records. Yes, it is possible to delete any number of records as long as there is sufficient space allocated for you RBS.

For now, you have to delete fewer records, then issue a COMMIT to clear the rollback. Then you can delete more records, issue COMMIT until you have deleted the 10k records.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform