Tuesday, April 30, 2013

Unlock Table Oracle


There have no any command  to unlock database.

After applying transaction such as Commit and Rollback table automatically unlocked.

Commit Transaction Used To Unlock Table:

This command is used to save the transaction explicitly from the movement the user log on to the data to the movement the executing Commit command or the movement to user executing Rollback command to till executing commit command.

Rollback Transaction Used To Unlock Table:

This command is used to discard the transaction from the movement the user log on to the database to till the execute Rollback command or executing Commit command into till executing Rollback command.


Tagged:

0 comments :

Post a Comment