Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: The easiest way to replicate an Oracle database.
Well...
the exp utility is not probably the best choice to backup
live databases but this is not your case i guess.
I will go like this:
Basic replication from the live to the new db
otherwise (if you don't want to touch the live db)
exp the live db
create the schema in the new db
disable constraint / import data / enable constraint
(you can even decide to import table by table respecting
the child/parent relationship - takes longer though)
for the updating issue you can create a sqllink between
the two dbs and retrieve the data from the live one through
views.
Giorgio
<saeedt7777_at_my-deja.com> wrote in message
news:95vjib$sg3$1_at_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 Fri Feb 09 2001 - 04:34:45 CST