catch.saravana
Member
What is the recommended way to delete a very large table without hampering the regular business operations?
1. DROP TABLE via DF script
2. FOR..EACH and DELETE records (all at once)
3. FOR..EACH and DELETE records (broken into smaller chunks like 10000 records per transaction)
4. PROUTIL TRUNCATE
5. SQL DELETE
or any other?
Note - We have to perform this operation on 9.1E.
1. DROP TABLE via DF script
2. FOR..EACH and DELETE records (all at once)
3. FOR..EACH and DELETE records (broken into smaller chunks like 10000 records per transaction)
4. PROUTIL TRUNCATE
5. SQL DELETE
or any other?
Note - We have to perform this operation on 9.1E.