Skip to Main Content

SQL Developer

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 check what changes are uncommitted?

PaavoJul 15 2016 — edited Jul 22 2016

When exiting SqlDeveloper it occasionally claims that there are uncommitted changes and it would be good to see what changes are pending and is it save to either commit or rollback those.

I have found out that by disconnecting database connections one by one I can isolate which database connection has uncommitted changes, because it prevents disconnect.

The problem in this is that sometimes there are no 'freehand' sql scripts pending commit but maybe some clicking around the object tree has made update which is not committed?

Is there method to check which action is pending commit or are there known features in sqldeveloper which are not auto-committing their changes.

rgrds paavo

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 19 2016
Added on Jul 15 2016
16 comments
20,462 views