Re: Oracle 8i Migration

> I've got an NT 4.0 server with Oracle 8i and I'm thinking to change
> operating system to windows 2003.
> Which is the safest way in order not to lose any data?
> Are there any problems installing Oracle 8i on Windows 2003?
> Thanx a lot

Kalimera Elia,
I have installed Oracle 8i (8.1.7) on Win2000 and 2003 server with absolutely no problem. I use export -> import for my backup needs, and it has been completely succesful when I used it to transfer a database. Only problem I had: the paths had to stay the same (like D:\Oracle in both OSs) *OR* I had to create the database and the tablespaces *before* the import (so the data files would be created).

My export is really simple, like that:

exp SYSTEM/MANAGER_at_ORACLE1 PARFILE=C:\scripts\oraexp.txt

and oraexp.txt is:

FULL=Y
FILE=D:\ORABACKUP\Full.dmp
BUFFER=2800000
GRANTS=Y
INDEXES=Y
CONSISTENT=Y
LOG=D:\ORABACKUP\full.log

Ofcourse that's my experience only, and I'm no Oracle guru. I suggest you try it, test it and, hopefully post the results here for us to know :-)

Hope that helps. Kalo kouragio !

-- 
Dimitris Andrakakis
Network administrator
METER-Consulting Engineers Ltd.