Oracle recommends building a new database and use export/import. You can
deinstall EE, install SE and then run catalog, catproc scripts, but you will
end up having invalid objects created by EE that SE doesn't know about.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Brian Tkatch" <SPAMBLOCK_brian.tkatch_at_shopsforme.com_SPAMBLOCK> wrote in
message news:htv0tuo57mi0arj26vm28ho0mhbom1u96c_at_4ax.com...
> On Tue, 12 Nov 2002 00:05:42 +0100, Sybrand Bakker
> <gooiditweg_at_sybrandb.demon.nl> wrote:
>
> >On Mon, 11 Nov 2002 17:41:37 -0500, Brian Tkatch
> ><SPAMBLOCK_brian.tkatch_at_shopsforme.com_SPAMBLOCK> wrote:
> >
> >>Oracle 8.1.7
> >>
> >>I was playing around with Oracle Enterprise Edition and had a database
> >>installed. I realized that I didn't need Enterprise, and figured that
> >>I might as well download the standard edition.
> >>
> >>1) Is there a place to download the Standard Edition? Or the Personal
> >>edition of 8.1.7?
> >>
> >>2) Is there a way to migrate from Enterprise Edition to Standard or
> >>Personal?
> >>
> >>Brian
> >
> >1) They currently can be downloaded at otn as usual, and are contained
> >in one file, choice which edition to be installed to be made at
> >installation.
>
> Well, I downloaded the EE file elsewhere and I am not sure that I saw
> the option to install only the standard edition. I'll surely look
> again. But, is it at the beginning or something?
>
>
> >2) The only way is to deinstall Oracle 8.1.7 EE and to install Oracle
> >8.1.7 SE.
> >Simple, is it not?
>
> That's fine. I'm just wondering if there's anything internal to the DB
> that won't work. For example, if the system tablespace decided to use
> a function-based index.
>
> If its just a deinstall/reinstall, that's ought to be easy.
>
> Brian
>
Received on Tue Nov 12 2002 - 09:44:25 CST
