RE: Cloning Data Only

  • From: "Sam Bootsma" <sbootsma@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 7 Jul 2005 12:35:08 -0400

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


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of GovindanK
Sent: July 6, 2005 12:28 PM
To: oracle-l@xxxxxxxxxxxxx; ganstadba@xxxxxxxxxxx
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.



On Wed, 6 Jul 2005 11:11:49 -0400, "Michael McMullen"
<ganstadba@xxxxxxxxxxx> 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
> --

Other related posts: