Re: The easiest way to replicate an Oracle database.

Fastest and easiest way is to shutdown the production databases. Ftp all datafiles, logfiles, controlfiles to the development
box. Then start the database on the
development box after changing
file names, if required. However, shutting down the production database may not
be an easy option.

Import process will continue
even if there is a data problem if the
tables are altered for deferred validation constraint.

Depending on the requirement, if
foreign key constraint is not strictly
enforced in a development environment, one can disable all constraints, then
continue with the data loading.

Later when the enable constraint
fails r, data may be checked and
updated on a case by case basis as required.

In other words ,data import and
foreign key constraint enabling is always a problem if data is not totally clean and correct, i.e all parent rows are not present.
 I haven't seen anthing easier than
copying the cold productio database files to start the developmet database whenever
a development database needs to be refreshed with production data.

Regards
Willy Received on Thu Feb 08 2001 - 21:27:52 CST