Wednesday, June 06, 2012

ORA-01089

This was tested on Oracle 9. If you are running some SQL in one session (in red):
 
SQL> l
  1  select count(*) from
  2  dba_tables a,
  3  dba_tables b,
  4* dba_tables c
SQL> /
 
... and you do a shutdown immediate in another session (in blue):
 
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
 
... the first session fails almost immediately with an ORA-01089:
 
SQL> l
  1  select count(*) from
  2  dba_tables a,
  3  dba_tables b,
  4* dba_tables c
SQL> /
dba_tables c
           *
ERROR at line 4:
ORA-01089: immediate shutdown in progress - no
operations are permitted
 
SQL>

No comments: