Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Copying v8.1.5 NT Database to 10g Win2003 Server?
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