删除Goldengate的时候删除不掉
1,、删除用户
SQL> dropuser ydsr1011 cascade;
drop userydsr1011 cascade
*
ERROR at line1:
ORA-00604:error occurred at recursive SQL level 2
ORA-20782:Oracle GoldenGate DDL Replication Error: Code :ORA-20782: Cannot
DROP objectused in Oracle GoldenGate replication while trigger is enabled.
Consult OracleGoldenGate documentation and/or call Oracle GoldenGate Technical
Support if youwish to do so., error stack: ORA-06512: at line 231
ORA-06512: at line957
drop trigger ggs_ddl_trigger_before
SQL> drop user gate01 cascade;
drop user gate01 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 tablealready in use
查出GOldengate用户的表
selecttable_name from tabs where table_name like 'GG%';
select sid,serial# from v$session where sid =
(selectsid from v$lock where id1 =
(selectobject_id from user_objects whereobject_name = upper('GGS_STICK')));
结束session:
alter systemkill session 'sid,serial#';
drop usergate01 cascade;