Re: sqlload table order

Guenter Radakovits wrote:
>
> jim nash wrote:
> >
> > When re-importing tables into a reorg'd database (via post 7.0
> > SQL*LOADER), to avoid constraint problems it appears
> > necessary to either disable constraints or to load tables in
> > hierarchical order.
> >
> > Does anyone have a query that can be used to relate the order
> > in which tables must be loaded?
> >
> > Thx,
> >
> > - Jim
>
> hi jim,
>
> try this
>
> select a.table_name,
> a.owner,
> a.constraint_name,
> a.constraint_type,
> b.table_name,
> b.owner,
> b.constraint_name
> from dba_constraints a, dba_constraints b
> where a.table_name = upper('&table')
> and b.r_owner = a.owner
> and b.r_constraint_name = a.constraint_name
> /

Can using start with... Connected by... to list the tables in order. (The syntax I forget, refer to manual) Received on Sun Apr 06 1997 - 00:00:00 CST