Re: Copying v8.1.5 NT Database to 10g Win2003 Server?

rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0411300503.760b08fc_at_posting.google.com>...
> Mark Bole <makbo_at_pacbell.net> wrote in message news:<5XPqd.51737$QJ3.37764_at_newssvr21.news.prodigy.com>...
> > SAP BASIS Consultant wrote:
> > > Hello,
> > >
> > > I installed Oracle 10g on Win2003. I created a database with the same
> > > name (Say TEST) as a v8.1.5/NT database on another server.

stuff deleted..

> 8.1.5 to 10g is not supported as FULL=Y (export and Import). However,
> if all the users are pre-created in the target 10g database then
> schema level import is an option. I would still favor upgrading to
> 8.1.7 and then do a full export to 10g. I think this is lesser of the
> two evils.
>
> >
> > If you don't have enough disk space for an export, you are in real trouble.
> >
> > As a side note, the jump from Windows NT 4.0 to W2k3 server might be
> > non-trivial as well.
>
> I have not tested copying NT/2000/XP files directly to 2003 to see if
> it works. It may or may not but since 2003 comes in 64 bit flavor also
> (Which OP did not mention if he is on 32 or 64 bit 2003)... I would be
> very hesitant in doing it as Oracle does not support 32bit database on
> 64bit 2003. Plus Oracle ships separate software for 2003 32bit and
> 64bit.
>

Thanks to all those who posted. Using a shared drive, I exported and imported the database as recommended.
> Regards
> /Rauf
Received on Wed Dec 01 2004 - 19:45:12 CST