Re: Using Data Dictionary to tables with Referential Integrity in proper order

Dan's answer is great, but I've got a question: load how using what?

Assuming empty tables all around? Or with stuff in some or all of them?

If they're empty, and your data source is consistent (hah, have heard THAT one too many times!) but seriously, if so, you could disable the constraints, load em up, and re-enable the constraints. If however your source is not reliable, that would be a mess.

How much data are we talking about in Gab and rows, and how many tables?

But yeah, if it is a complicated thing, you'd probably be best off having a nice stored procedure to do the dependency tree analysis.

An E/R diagram out of Designer would help a lot, too!

RSH.
"damorgan" <dan.morgan_at_ci.seattle.wa.us> wrote in message news:3C840C96.3C08DF97_at_ci.seattle.wa.us...
> Look at all_dependencies and all_constraints.
>
> Daniel Morgan
>
>
>
> Brent Eamer wrote:
>
> > I would like to be able to enter a table name and have a procedure list
the
> > order in which to load tables.
> >
> > Anybody done this?
> >
> > I have tried but have not found a solution.
>
Received on Mon Mar 04 2002 - 18:38:32 CST