Perl-Sensitive Sunglasses | |
PerlMonks |
Re: deep copy of complex database tablesby Thilosophy (Curate) |
on Jun 21, 2005 at 11:04 UTC ( [id://468626]=note: print w/replies, xml ) | Need Help?? |
You may want to look at Oracle-supplied utitilies, in particular exp, which dumps consistent snapshots of parts (or the whole) of the database. You can then later import these with the imp utility.
If you are only concerned with a few tables, you can just do something like the following (which would also work across database links if you set those up):
What do you mean by "complex" tables that need a "deep copy"?
In Section
Seekers of Perl Wisdom
|
|