AW: Deep Copy a Record

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_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
Cc: oracle-l_at_freelists.org
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_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 4059


 <mailto:mark.bobak_at_il.proquest.com> mark.bobak_at_proquest.com

 <http://www.proquest.com> www.proquest.com

 <http://www.csa.com> www.csa.com


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