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
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: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dbms_redefinition.

Regards
Michel
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.
Previous Topic: Overhead of materialized view log on DML
Next Topic: Problem in MV
Goto Forum:
  


Current Time: Thu Mar 28 09:04:12 CDT 2024