OraFAQ Forum: Streams & AQ » two way for renaming schema (how use?)

Home » Server Options » Streams & AQ » two way for renaming schema (how use?) (10.2.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

two way for renaming schema (how use?) [message #409366]

Mon, 22 June 2009 05:54

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

Report message to a moderator

Re: two way for renaming schema (how use?) [message #409392 is a reply to message #409366]

Mon, 22 June 2009 07:39

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: two way for renaming schema (how use?) [message #409397 is a reply to message #409392]

Mon, 22 June 2009 07:47

narges
Messages: 11
Registered: December 2004

Junior Member

hi
could you give me the documentid or sample code because i havent access to metalink.

Report message to a moderator

Re: two way for renaming schema (how use?) [message #409401 is a reply to message #409397]

Mon, 22 June 2009 07:53

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: two way for renaming schema (how use?) [message #409497 is a reply to message #409401]

Mon, 22 June 2009 23:17

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 02 13:02:49 CST 2025