Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Cloning Data Only

Re: Cloning Data Only

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Wed, 06 Jul 2005 09:28:20 -0700
Message-Id: <1120667300.5429.237878274@webmail.messagingengine.com>


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
Received on Wed Jul 06 2005 - 11:30:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US