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
Oracle Enterprise Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 60
- Joined: Tue Sep 20, 2011 10:44 pm
- Location: INDIA
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.
"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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers