Information générale
Titre:
Removing rollback segments
Is there possible to remove all rollback segments ? I need to delete bunch of rows (I cannot truncate the tables since there is a criteria for the deletes) from tables in order to re-load them aftrewards. I am doing ETL work, not OLTP. I do not need rollback segments. When I try to delete 500k-1M rows, I get out of rollback segments. But I want to delete these rows anyway, I will not issue a rollback afterwards. My dba cannot allocate me more space for rbs. So I create a small PL/SQL stored procedure that delete and commit at each 250K rows. But, since it uses rbs, it takes long time to execute.
Can somebody help me on this ?
Thank you,
Christian
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement