Re: sqlload table order

From: Guenter Radakovits <guenter.radakovits_at_sea.ericsson.se>
Date: 1997/04/01
Message-ID: <33414000.35A5@sea.ericsson.se>#1/1

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 / Received on Tue Apr 01 1997 - 00:00:00 CST