Ken,
Do a full export as user sys. Then create a new userid to act as the
owner of those non-sys and non-system tables.
Do an alter user owner_of_tables default tablespace
tablespace_for_application_tables;
Do an import of the application tables using the table (or tables - I can't
remember) option of the imp command.
You probably will need to use fromuser=SYS touser=owner_of_tables as well.
>From the unix operating system prompt you can use the exp help=y and imp
help=y commands to get help on the syntax
for export and import. The Server Utilities User's Guide has lots of text
and examples for export and import. You can
also query Metalink for something moving tables from one schema to another
using export and import. There should
be a few notes in there outlining the exact steps to use.
Cherie
Ken Janusz
<ken.janusz@su To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
fsys.com> cc:
Sent by: Subject: Move DB to Another Schema
[EMAIL PROTECTED]
om
12/21/01 08:55
AM
Please respond
to ORACLE-L
I can't find any details of this in any of my documentation. I originally
created my DB as SYS. I have setup a new user and need to move my DB /
Tables, etc. to the new schema. How do I go about this? Can I do it via
SQL Plus or do I need to do it via svrmgr? Or, would it just be easier to
create a new DB (DDL SQL script) as the new user?
Thanks,
Ken Janusz
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
