Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Copying v8.1.5 NT Database to 10g Win2003 Server?

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

From: Mark Bole <makbo_at_pacbell.net>
Date: Tue, 30 Nov 2004 01:22:09 GMT
Message-ID: <5XPqd.51737$QJ3.37764@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.
[...]
>
> I also created the same Windows directory structure for Oracle in
> Win2003 (10g) as in NT (8i), and adapted the necessary env.
> variables and/or registry parameters. 'listener.ora' and
> 'tnsnames.ora' have also succesfully been adapted.
>
> Will I be able to do a straight copy of the source 8i files into
> the target 10g Oracle directory structure, and reset the logs
> in the target 10g database when opening it?
>
> I realize that an export/import may be more straightforward, but
> the server hosting the source 8i database may not have the disk
> space necessary for an export.
> SAP BASIS Consultant

But to get from 8.1.5 to 10g will at minimum require a stop at 8.1.7.4. Which implies at least two migrations (or upgrades, I never could remember the subtle difference), in addition to another complete Oracle home install (plus patch). This could get a little tricky.

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.

-Mark Bole Received on Mon Nov 29 2004 - 19:22:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US