-
stream&rename schema
Hi,
I want to replicate SCHEMA_A.TABLEX TO SCHEMA_B.TABLEX
i know i could use of:
DBMS_STREAMS_ADM.RENAME_SCHEMA(v_dml_rule,'SCHEMA_A','SCHEMA_B');
OR
dbms_streams_adm.rename_table(
rule_name => v_dml_rule
,from_table_name => 'SCHEMA_A.TABLEX'
,to_table_name => 'SCHEMA_B.TABLEX'
,step_number => 0
,operation => 'ADD');
end;
but i dont know how could i use that?
if any one has sample code from metalink please give me the documentID or post
sample code .
thanks in advance.
Sandy
-
You may want to check for a similar example here.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|