- Get link
- X
- Other Apps
- Get link
- X
- Other Apps
You want to drop user SYSMAN and you see error?
You can try:
SQL> drop user sysman cascade; drop user sysman cascade * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-24170: SYSMAN.MGMT_NOTIFY_Q_R is created by AQ, cannot be dropped directly ORA-06512: at "SYS.DBMS_RULE_ADM", line 158 ORA-06512: at line 1 |
You can try:
SQL> shu immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup restrict ORACLE instance started. Total System Global Area 523108352 bytes Fixed Size 1314492 bytes Variable Size 100663620 bytes Database Buffers 415236096 bytes Redo Buffers 5894144 bytes Database mounted. Database opened. SQL> drop user sysman cascade; User dropped. SQL> shu immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 523108352 bytes Fixed Size 1314492 bytes Variable Size 100663620 bytes Database Buffers 415236096 bytes Redo Buffers 5894144 bytes Database mounted. Database opened. |
Comments
Post a Comment