Originally posted by rajabalachandra
you can delete from the table with logging off.
here you do not need to worry about rollback segments.
careful. you won't be able to go back in case any problem.
eg.
delete from table1
where x=y nologging;
- raja balachandran
Wrong! Nologging has no effect on rollback generation. Better delete in small bathces if you do not have sufficient rollback space.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Reply With Quote