rollbacksegments

Oracle Rollback Segments and ADO.NET

I am using an ancient version of Oracle (8.something) and my ADO.NET application needs to do some fairly large transactions. Large enough to not fin in our small rollback segments. Now we have a large rollback segment as well but it is not used by default. Oracle has a command to select the rollback segment to be used (SET TRANSACTION U...

drop/truncate and rollback segment

I know that drop removes the data as well as the table structure whereas truncate retains table structure. Does drop/truncate write to roll back segment ? ...