Oracle 10g Database Copy from one machine to another - Windows XP
Posted on 2007-04-06
I have Oracle 10g installed on 2 different machines both with Windows XP. I need to copy the database from one machine into another. The database is about 10GB and has links to metadata. I tried the method of copying datafiles, log files & init files with creation of new control files. But this does not work smoothly and I was not successful several times I tried. I am trying typical imp/exp as well as impdp/expdp for the same, but they are physical path dependent. i.e., the tablespace path & other file paths are stored on absolute basis and are not relative. When I export from one machine wherein datafiles are in f: drive and try to import the whole database dump into another system with only c: drive (no f: drive), it starts giving errors. Please let me know if there is any easy and proven method for the same.