Re: Move DB to Another Schema

From: Stephane Faroult <sfaroult_at_oriole.com>
Date: Sat, 22 Dec 2001 00:33:25 -0800
Message-ID: <F001.003E2313.20011222001519@fatcity.com>

John Kanagaraj wrote:
>
> Ken,
>
> SYS objects are NOT exported since an import of SYS would basically then
> import database metadata. The only method is to create another schema (not
> SYSTEM!) and move these tables into the new schema using a series of CTAS.
> If you have the DDL scripts, then run them against the new user rather than
> SYS (did you run them using SVRMGRL connected as INTERNAL before?)
>
> Hope everything goes well with you and the family this Christmas season!
> John Kanagaraj
> Oracle Applications DBA
> DBSoft Inc
> (W): 408-970-7002
>

John,

I agree with you for a full export, and (I have just checked) a OWNER=SYS export exports everything but tables. But there is no such limitation with a TABLES= export :

[oriole_at_frlinux1 oriole]$ exp system/xxx tables=sys.obj$

Export: Release 8.1.7.0.1 - Production on Sat Dec 22 09:06:03 2001

Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production With the Partitioning option
JServer Release 8.1.7.0.1 - Production
Export done in US7ASCII character set and US7ASCII NCHAR character set

About to export specified tables via Conventional Path ... Current user changed to SYS

. . exporting table                           OBJ$       3016 rows

exported
Export terminated successfully without warnings

so CTAS is not the ONLY option.

-- 
Regards,

Stephane Faroult
Oriole Ltd
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Sat Dec 22 2001 - 02:33:25 CST