Same exact box, same instance. On NT, I found that I can do an ORADIM -delete, deinstall the software, reinstall the new software, do and ORADIM -new, and then run u0801050.sql. Problem is it leave all of the remnants of enterprise options such as MDSYS,CTXSYS, and AURORA$ORB$UNAUTHENTICATED users.
>From: "Kevin Kostyszyn"
>Reply-To: ORACLE-L@fatcity.com
>To: Multiple recipients of list ORACLE-L
>Subject: RE: Enterprise VS. Standard???
>Date: Wed, 02 May 2001 08:56:54 -0800
>
>On the same box or different box? That is how I did it, of course it was a
>really small schema.
> -----Original Message-----
> From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Fred Smith
> Sent: Wednesday, May 02, 2001 12:20 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Enterprise VS. Standard???
>
>
> Does anyone out there know what the best method would be to migrate from
> Oracle 8.1.6 Enterprise Edition to Oracle 8.1.6 Standard Edition?
>
> It appears from the docs that the only way to migrate from Enterprise to
> Standard is to do an entire rebuild of the database. (Export, de-install,
> re-install, Build all tablespaces, etc. and Import). Is this correct?
>
> OS: Windows NT 4.0
> DB: Oracle 8.1.6 Enterprise (going to Standard)
>
> Thank you.
> -Fred Smith
>
>
>
>
>----------------------------------------------------------------------------
>--
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>
> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
>Fred Smith INET: fred_fred_1@hotmail.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@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).
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Fred Smith
INET: fred_fred_1@hotmail.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@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 Wed May 02 2001 - 15:43:38 CDT