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

Home -> Community -> Usenet -> c.d.o.server -> Re: 100% Schema Duplication

Re: 100% Schema Duplication

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 21 Apr 2007 12:49:56 -0700
Message-ID: <1177184996.646053@bubbleator.drizzle.com>


hpuxrac wrote:

> On Apr 20, 2:14 pm, "agill" <a..._at_mailinator.com> wrote:

>> 10gR2
>>
>> Hi a quick question:
>>
>> Need to duplicate a schema 100%, including Pkg, Types, all objects generated
>> by XDB etc.
>> Does expdp/impdp do that ?
>>
>> thanks
>> adam
> 
> Well geez yeah but of course you can also use old fashioned export/
> import

Why would someone want to use a legacy tool and not improve their skill set?

Given we do not know the number of objects and records wouldn't it be best to recommend the more capable tool?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Apr 21 2007 - 14:49:56 CDT

Original text of this message

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