Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DELETE without loading rollback statements
Message
 
 
À
07/03/2001 13:51:36
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Québec, Canada
Information générale
Forum:
Oracle
Catégorie:
Autre
Divers
Thread ID:
00482829
Message ID:
00482928
Vues:
14
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform