Re: The easiest way to replicate an Oracle database.

Unix?

Identify all your d/b files, shut down + tar them up.

Slap the tar file on the target machine and untar.

If in doubt, get your Unix administrator to help.

Or use ftp or rcp. Tar is the simplest I think.

In article <95vjib$sg3$1_at_nnrp1.deja.com>,   saeedt7777_at_my-deja.com wrote:
> 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/
>

--

Cheers

Glenn Baron

Leigh-on-Mendip
Somerset


Sent via Deja.com
http://www.deja.com/