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>