Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> sqlload table order
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,