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 -> Re: The easiest way to replicate an Oracle database.

Re: The easiest way to replicate an Oracle database.

From: Giorgio Sorbara <NoSp_at_m>
Date: Fri, 9 Feb 2001 11:34:45 +0100
Message-ID: <3a83c7c5$0$4496$73bec57d@news.be.uu.net>

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

Original text of this message

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