Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Method to replicate certain tables

Method to replicate certain tables

From: <MSUDad_at_gmail.com>
Date: 24 Aug 2005 19:30:21 -0700
Message-ID: <1124937021.099066.86250@g14g2000cwa.googlegroups.com>


I have a database (Oracle 9i) with approximately 100 tables in our production facility and need to replicate most but not all of the tables to a database at our preproduction facility. We can't overlay all of the tables because certain preprod tables contain important info different from Prod. I need to perform this replication on a monthly basis and it must be done as quickly as possible.

Doing a simple export/import of each table has proven to be very tedious and takes much too long.

Any suggestions on methods to perform this quickly? Received on Wed Aug 24 2005 - 21:30:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US