Generating more archive logs
my env is Oracle 10gR2,RHEL4.0,
In my dev Db one of user table contain more than 10Lac Records .in that some duplicate are present.
I am deleting record by record it is generating more Archive log file.due to that my is database hanged.
can you tell me what are the possible reasons for gen of more arch file.
If the answer is not in previous post and if you're deleting (much) more than you're keeping (i mean very large volumes) i suggest :
(create a backup table as the one you're deleting in (same structure-> not constraints))
- backup the rows you want to keep in an other table
- truncate the original table
- re-insert the backuped rows
- truncate the backuped table