Home » Server Options » Streams & AQ » two way for renaming schema (how use?) (10.2.0)
two way for renaming schema (how use?) [message #409366] Mon, 22 June 2009 05:54 Go to next message
narges
Messages: 11
Registered: December 2004
Junior Member
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.
narges
Re: two way for renaming schema (how use?) [message #409392 is a reply to message #409366] Mon, 22 June 2009 07:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is indeed notes on this in Metalink.
I read it I think you should be able to find it.

Regards
Michel
Re: two way for renaming schema (how use?) [message #409397 is a reply to message #409392] Mon, 22 June 2009 07:47 Go to previous messageGo to next message
narges
Messages: 11
Registered: December 2004
Junior Member
hi
could you give me the documentid or sample code because i havent access to metalink.
Re: two way for renaming schema (how use?) [message #409401 is a reply to message #409397] Mon, 22 June 2009 07:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you don't have access to MetalinkI can't give you the note.
But you may find example in Streams documentation.

You have to read and understand the following chapter:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14229/strms_transform.htm#STRMS106

Regards
Michel
Re: two way for renaming schema (how use?) [message #409497 is a reply to message #409401] Mon, 22 June 2009 23:17 Go to previous message
narges
Messages: 11
Registered: December 2004
Junior Member
Thank you Michel.
I asked my company and they give me Metalink access, I searched and found some code in 9i&10g but the best was SAMPLE CODE with DocID: 784899.1 in 10g but this sample code is implemented on one database with two different schemas. I want to implement between 2 database then changed the code for 2 database but doesn't work!
DB1.net(Schema_A.tablex) --->DB2.net(Schema_B.tablex)

If you know DocID for implementing this scenario PLEASE give it to me then I could found it in metalink faster.

thanks alot.
Narges

Previous Topic: Stream implemetation - general view
Next Topic: what's wrong in my script! my replication dosnt work without error
Goto Forum:
  


Current Time: Thu Mar 28 09:31:44 CDT 2024