Re: deep copy of complex database tables

If you *do* fancy reinventing the wheel, look at the following tables in the data dictionary:

to figure out what tables you need to copy, then CREATE TABLE foo ... AS SELECT ...

Comment on Re: deep copy of complex database tables Download Code

Replies are listed 'Best First'.
Re^2: deep copy of complex database tables by hartwig (Sexton) on Jun 23, 2005 at 13:20 UTC
Before writing nifty comments about reinventing- try to read the question carefully :~\| - Assume you have a graph-structure which is circular and fairly easy to construct with the given two tables - it is non trivial to extract this structure from the graph. As I mentioned - what I like to have is a deep copy (including all 'sub-table-entries') - any ideas?	[reply]