You encountered an insufficient privilege error in the middle of a long transaction.

Oracle 1z0-908 Question Answer

The database administrator is informed and immediately grants the required privilege:

GRANT UPDATE ON world.city TO ‘user1’;

How can you proceed with your transaction with the least interruption?

Roll back the transaction and start the transaction again in the same session.

Re-execute the failed statement in your transaction.

Change the default database and re-execute the failed statement in your transaction.

Close the connection, reconnect, and start the transaction again.

1z0-908 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"