Re: Changing schema?

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 31 Jul 2006 08:23:34 -0700
Message-ID: <1154359415.713715@bubbleator.drizzle.com>

Major wrote:
> Oracle version 9 g?) and 10.2 G
>
> What is a easy way to move all objects from schema to other one?
> Exp/Imp (with remapping schema)?
> Do is in the DBA studio any other ways?

The DBMS_SCHEMA_COPY built-in package. Use the CLONE procedure.

A working demo is in Morgan's Library at www.psoug.org.

-- 
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 Mon Jul 31 2006 - 10:23:34 CDT