删除GOldengate的时候删除不掉

删除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;