How to drop my goldengate user? When I drop the user ogg ,occured ORA 14452
1000662May 8 2013 — edited May 17 2013HI
When I drop the user ogg ,occured ORA 14452 ,and i can not kill the session belongs to the user!
SQL> drop user ogg cascade;
drop user ogg cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-14452: attempt to create, alter or drop an index on temporary table already in use
SQL> select sid,serial#,username from v$session where username='OGG';
SID SERIAL# USERNAME
---------- ---------- ------------------------------
227 13581 OGG
1082 6 OGG
SQL> alter system kill session '1082,6';
System altered.
SQL> select sid,serial#,username from v$session where username='OGG';
SID SERIAL# USERNAME
---------- ---------- ------------------------------
227 13581 OGG
1082 6 OGG