Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Move DB to Another Schema
Joe Raube wrote:
> 1 - never create objects as SYS
> 2 - svrmgr is gone in 9i - stop using it
>
> I would drop all user objects that you created as SYS,
> and recreate using a DDL script.
>
> -Joe
Joe,
I would beg to differ on the use of svrmgrl over sqlplus in 8.1.x. None other than Tom Kyte corrected me on the (non)use of sqlplus in running scripts as SYS such as catalog.sql. For 8.1.6, 8.1.7, you are still recommended to use svrmgrl for running scripts as SYS.
you can find the post over at google - it was in comp.databases.oracle.server
Paul
happy holidays.
http://www.planetchristmas.com/pictures_2001.htm
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: paled_at_home.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 Fri Dec 21 2001 - 15:45:16 CST
![]() |
![]() |