Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to COMMIT all open transactions?

632013Feb 24 2009 — edited Feb 24 2009
Hi,

I have 10.2.0.4 on Windows.

I need to run a critical month-end DataPump export of 1 schema. Easy enough. The system will be in-use by the end users when this runs. Not many maybe 10 users will be connected and it is not a very large db - 10 GB.

My concern is that there may be a few uncommitted transactions hanging around that may not be written to the dump file. If I run COMMIT; that only commits for my session, right? How can I force all open transactions for all users to be committed just before I run the DP export?

-OR- is DataPump so sophisticated that it will auto. commit them first?

Thanks for your ideas. John
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2009
Added on Feb 24 2009
#general-database-discussions
10 comments
2,468 views