The easiest way to replicate an Oracle database.

From: <saeedt7777_at_my-deja.com>
Date: Fri, 09 Feb 2001 02:10:23 GMT
Message-ID: <95vjib$sg3$1@nnrp1.deja.com>

Folks,

We have a "live" production database that we want to replicate to another development machine. The data does not need to be updated to the minute. We can not do backup/restore. Also when we use import (the imp utility) it complains about foreign keys being non existent and does not create some of the constraints.

It seems like the "imp" utility is actually validating some of the data in the database. Also I have heard that exp/imp utilities are not really suitable to export "live" databases.

Is there a flag to tell imp utility to ignore errors and create the constraints no matter what ? Is there an easier and a faster way to replicate a "live" production database (full database replication) ?

I am interested to know about your experiences.

Thanks,
Sam

Sent via Deja.com
http://www.deja.com/ Received on Thu Feb 08 2001 - 20:10:23 CST