Re: Data load ideas

From: Paul Baumgartel <treegarden_at_yahoo.com>
Date: Wed, 28 Apr 2004 14:38:49 -0700 (PDT)
Message-ID: <20040428213849.17309.qmail@web13424.mail.yahoo.com>

Re-submitted with less quoting.

> Jared,
>
> We currently disable FKs because current tool (never really meant for
> production use...you know how that goes) uses exp / imp, and tables
> come in alphabetical order, thus children are loaded before parents
> in
> some cases. Being lazy, I figured I'd use deferrable (and deferred)
> FK
> constraints rather than figuring out the parent-child dependency tree
> (although I'm now shamed into figuring it out, just to prove that I
> can). Yes, PL/SQL, Perl, etc. should be able to handle this fine...I
> just wanted to make sure that I wasn't overlooking something simpler
> (like transportables, or exchange partition; not that they'd
> necessarily be simpler once everything was considered).
>
>
>
> --- Jared Still <jkstill_at_cybcon.com> wrote:
> > Paul,
> >
> > I don't get it. Without a better understanding of your app
> > it makes it rather difficult.
> >
> > For instance, why are there FK constraints that need to be
> > disabled during a load?
> >
> > If the tables are loaded in the correct order, and load
> > script via SQL*Loader, PL/SQL, Perl or whatever you use
> > should be able to handle this.
> >
> > I've not worked at an ASP, but have developed on a system
> > where many customers data had to be loaded on a daily basis.
> >
> > What is preventing a procedural process with PL/SQL batch
> > loading from being used?

Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Apr 28 2004 - 16:36:00 CDT