AW: Deep Copy a Record
Date: Fri, 16 May 2008 11:47:01 +0200
Surprising that you expect Oracle to do this job... If you could try to figure out what has to be coded to handle each and every possible way of implementation and dependencies of tables, then you could have a (very small) glimpse what Oracle has to deal with if they implemented it.
And we did not talk about referential integrity or partitioning, etc which have to be maintained, too.
my 2 cents,
Von: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] Im
Auftrag von Dixit, Sandeep
Gesendet: Freitag, 16. Mai 2008 11:18
An: Bobak, Mark
Betreff: RE: Deep Copy a Record
There must be a good reason why this features is not given.
Is there a place to discuss new features or unavailable features or to put forward the suggestions?
From: Bobak, Mark [mailto:Mark.Bobak_at_proquest.com]
Sent: Thursday, May 15, 2008 9:40 PM
To: Dixit, Sandeep; oracle-l_at_freelists.org Subject: RE: Deep Copy a Record
Not without writing code, no.
-- Mark J. Bobak Senior Database Administrator, System & Product Technologies ProQuest 789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346 +1.734.997.4059 or +1.800.521.0600 x 4059Received on Fri May 16 2008 - 04:47:01 CDT
ProQuest...Start here. From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dixit, Sandeep Sent: Thursday, May 15, 2008 9:53 AM To: Dixit, Sandeep; oracle-l_at_freelists.org Subject: Deep Copy a Record Is there a way to deep copy a Record into same schema? For example, if I copy a Department, all the Employees under it should be copied having reference to new Department.. and so on.. Sandeep. -- http://www.freelists.org/webpage/oracle-l