Tuesday, October 16, 2012

ORA-01097

I did this on Oracle 11.2.0.2.7. While testing something completely different, I noticed that you cannot close a database from a session which has an uncommitted transaction:
 
SQL> show user
USER is "SYS"
SQL> delete aud$;
 
38 rows deleted.
 
SQL> shutdown
ORA-01097: cannot shutdown while in a transaction - commit or rollback first
SQL> commit
  2  /
 
Commit complete.
 
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

No comments: