RE: Cloning Data Only

Thanks everybody, for your contributions. I will go back to our Developers with Mike's idea.

Sam.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of GovindanK Sent: July 6, 2005 12:28 PM
To: oracle-l_at_freelists.org; ganstadba_at_hotmail.com Subject: Re: Cloning Data Only

Mike's suggestion sounds the closest. Bottomline the DDLs should be kept track of so too the changes to the packages and changes if any that would have taken place to the data. Sometimes new indexes might have been created and other grants and privs given.

HTH GovindanK

On Wed, 6 Jul 2005 11:11:49 -0400, "Michael McMullen" <ganstadba_at_hotmail.com> said:
> How about export dev/test before the clone, run the clone and then
> run the import with ignore=n, only packages/tables that didn't exist
> in the clone will import. You'll miss ddl on tables but you can't
> get it all.
>
> Mike
> --

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l