Re: Migrating from Enterprise Edn to Std Edn

Thanks!

The problem is we dont have the room to bring down the database for several hours for an exp/imp.. I'm investigating whether I could recreate the dictionary objects with the SE script and then corrct any discrepencies (although this may not be supported by oracle )

what do you think?

"stic" <stefantura_at_klub.chip.pl> wrote in message news:<cd5bqp$3li$1_at_news.dialog.net.pl>...
> Uzytkownik "Thomas" <manojtom007_at_yahoo.com> napisal w wiadomosci
> news:65182aad.0407141338.71aa60ab_at_posting.google.com...
> > How can I migrate one of my databases (9i/Linux) from the current
> > Enterprise edition to Std Edn..
> >
> > The only Solution I saw was to do export and import.. any one know of
> > any other way?
>
> Yeap,
> Pass data/users/indexes/all others obyects you really need, between two
> instances of Oracle - but this work only if you don't rellay on any
> partition/spatial form Ent. I wonder why but this doesn't work if I used
> Ent. special elements (which are st Std. too, but I couldn't manage to move
> one database setting to the other...)
>
> Hope it could give a ray of light to your problem
>
> Anyway exp / imp I the best solution, with Direct Path, even the speedest I
> know.
Received on Thu Jul 15 2004 - 15:48:38 CDT