Home » Server Options » Replication » Table Replication (Oracle 10g, hpux 9000)
Table Replication [message #403502] Fri, 15 May 2009 23:00 Go to next message
bakalus
Messages: 3
Registered: October 2007
Location: Georgia
Junior Member
I have to reorganize one table that related to several other tables. The reorg is too slow when it runs on this table. I would like to create one image of the table and synch it with the original one in real time. So when I run the reorg, I will use the image table that does not constrained by indexes and other objects. Once the reorg is done, I would like to rename the table. Now, my question is how could I do the replication in real time? Your help is appreciated.
Thanks
Bak

Report message to a moderator

Re: Table Replication [message #403506 is a reply to message #403502] Sat, 16 May 2009 01:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
dbms_redefinition.

Regards
Michel

Report message to a moderator

Re: Table Replication [message #403610 is a reply to message #403506] Sun, 17 May 2009 09:18 Go to previous message
bakalus
Messages: 3
Registered: October 2007
Location: Georgia
Junior Member
thank you for the info. I will look into it.

Report message to a moderator

Previous Topic: Overhead of materialized view log on DML
Next Topic: Problem in MV
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 21 11:57:37 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.