Re: Changing schema?

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 01 Aug 2006 08:19:42 -0700
Message-ID: <1154445583.40547@bubbleator.drizzle.com>

Major wrote:

>> Your post leaves a few questions open:
>> * Are we talking about two schemas on the same or on different
>> databases?

>
> Same.
>

>> * From 9i to 10g2 or vice versa or on the same?

>
> I should move schemas from 9i to 9i and 10g2 to 10g2.

Use DBMS_SCHEMA_COPY.

-- 
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 Tue Aug 01 2006 - 10:19:42 CDT