怎么清掉apply 的INSTANTIATION

netbanker

查 10G db:
col source_database format a25 wrap
col object HEADING 'Database|Object' format a45
col instantiation_scn format 9999999999999999
col apply_database_link HEAD 'Database Link|for Remote|Apply' format a25 wrap

select source_database, source_object_owner||'.'||source_object_name OBJECT,
   ignore_scn,  instantiation_scn, apply_database_link DBLINK
from dba_apply_instantiated_objects order by source_database, object;


Source Database  Database Object   IGNORE_SCN  INSTANTIATION_SCN  Apply  DBLink
STRM10.WORLD  BB.ONEWAYDEPT           0                   28830896


只是知道怎么删掉capture 的INSTANTIATION，apply的怎么删掉呢？

yanggq

you want to destroy the whole streams env? or just want to drop the apply?

zhouwf0726

He can use this procedure to drop a table from the capture but can not from the apply.

DBMS_CAPTURE_ADM.ABORT_TABLE_INSTANTIATION(table_name  => '');

netbanker

原帖由 yanggq 于 2009-1-16 14:11 发表
you want to destroy the whole streams env? or just want to drop the apply?

just drop the apply init point as u can see for table BB.ONEWAYDEPT.

not drop apply process or detory stream env.

netbanker

table BB.ONEWAYDEPT already dropped, rules removed as well...