DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: stream&rename schema

Hybrid View

  1. #1
    Join Date
    May 2010
    Posts
    12

    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

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    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
  •  


Click Here to Expand Forum to Full Width