DSXchange

Hi All,

I just have a quick question in oracle enterprise stage in 7.5 where in I am trying to write data to a table. My question is how does stage peforms the commit on the table. Can I do a rollback once the table has been loaded.

Regards

Kumar

From what I recall, there are a couple of $APT variables that control the commit level, either by time or row count. I don't recall a discrete option in the stage itself. Of course it depends on if you are doing a "Load" or not as no commits are done and there's no rolling back when you use sqlldr.

"Once the table has been loaded" implies commited data to me and in that case there's no rollback as that applies only to uncommited rows.