Re: Tool
Date: 2000/06/07
Message-ID: <8hkt9p$fed$1_at_nnrp1.deja.com>#1/1
Frank,
a solution might be to disable all the foreign key constraints, then insert all the data and then enable alll the disabled constraints again. Works for me most of the times.
hth,
Bert Jan Meinders
Oracle DBA
ASR-ICT
In article <393d5478_at_news.ecore.net>,
"Frank Bluemel" <fbluemel_at_nbg.netdiscounter.de> wrote:
> Hi,
>
> i will fill a separate database from a source database. I have write
> Procedure to do that, but the problem is, the source database is a
> produktion database. The problem when i make a insert in the
destination
> database i get the error parent key not found while the database is
not
> aktuell.
> I'am serching for a tool what do the following.
>
> 1. Insert and Update data in a destination database whitout cancel the
> process.
> 2. Variable select statements for the query in the source database
> 3. scheduling from differend statements
> 4. connection over sql*net or odbc
>
> can anyone tell me a program who do this.
>
> Frank
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Jun 07 2000 - 00:00:00 CEST