开一个sqlplus conn aa/aa
在开一个sqlplus conn sys/liang as sysdba
SQL> drop user aa;
drop user aa
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
SQL> select sid,serial# from v$session
2 where username='AA';
SID SERIAL#
---------- ----------
136 33
SQL> alter system kill session '136,33';
System altered.
SQL> drop user aa;
drop user aa
*
ERROR at line 1:
ORA-01922: CASCADE must be specified to drop 'AA'
SQL> drop user aa cascade;
drop user aa cascade
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kzdukl2], [46320], [81], [], [],
[], [], []
怎么出现ora-600。
在开一个sqlplus conn sys/liang as sysdba
SQL> drop user aa;
drop user aa
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
SQL> select sid,serial# from v$session
2 where username='AA';
SID SERIAL#
---------- ----------
136 33
SQL> alter system kill session '136,33';
System altered.
SQL> drop user aa;
drop user aa
*
ERROR at line 1:
ORA-01922: CASCADE must be specified to drop 'AA'
SQL> drop user aa cascade;
drop user aa cascade
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kzdukl2], [46320], [81], [], [],
[], [], []
怎么出现ora-600。