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, Torsten. _____ Von: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] Im Auftrag von Dixit, Sandeep Gesendet: Freitag, 16. Mai 2008 11:18 An: Bobak, Mark Cc: oracle-l@xxxxxxxxxxxxx Betreff: RE: Deep Copy a Record Surprising, 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? Sandeep. From: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxx] Sent: Thursday, May 15, 2008 9:40 PM To: Dixit, Sandeep; oracle-l@xxxxxxxxxxxxx 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 4059 <mailto:mark.bobak@xxxxxxxxxxxxxxx> mark.bobak@xxxxxxxxxxxx <http://www.proquest.com> www.proquest.com <http://www.csa.com> www.csa.com ProQuest...Start here. From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dixit, Sandeep Sent: Thursday, May 15, 2008 9:53 AM To: Dixit, Sandeep; oracle-l@xxxxxxxxxxxxx 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.