Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> loading a sample set of data

loading a sample set of data

From: Doug Nichols <doug_x_nichols_at_yahoo.com>
Date: 11 Oct 2001 11:10:10 -0700
Message-ID: <78443f00.0110111010.eb77a35@posting.google.com>


Does anyone have a (pl/sql or sql) scripts that can build the load order for a group of tables in such a way as I can pick a table to load a subset and then load only the minimum data from other tables so that the fks, pks, etc are still intact?

It is basically a tree problem: node a is loaded, then other nodes are loaded acccording to their fks, pks etc. Not neccesarily easy, but do able I'm not interested in re-inventing anything..

Thanks for you assist!

ciao
dn Received on Thu Oct 11 2001 - 13:10:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US