Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: loading a sample set of data
I kept waiting to see a reply. I'd be interested in seeing solutions. I heard that there is a commercial product that could give you "slices of data" but I don't think it builds the tables.
When I imagine how to do this, I easily see problems. Would that it were a tree problem. You only need one loop to make any tree walking algorithm go crazy.
Please pass back any solutions you might find.
Doug Nichols wrote:
>
> 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 Tue Oct 23 2001 - 23:21:29 CDT