gweidner
asked on
Oracle 10g Database Copy from one machine to another - Windows XP
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Techies.....
I tried several alternative methods with all of your help and finally was successful by copying the DBCA template from one system to another.
That works better without any complication of path dependancy.
Thanks again to all.
I tried several alternative methods with all of your help and finally was successful by copying the DBCA template from one system to another.
That works better without any complication of path dependancy.
Thanks again to all.
A *C* ?
Thanks for the points, but you may want to take a look at the FAQ concerning the grading
https://www.experts-exchange.com/help.jsp#hi73
Thanks for the points, but you may want to take a look at the FAQ concerning the grading
https://www.experts-exchange.com/help.jsp#hi73
ASKER
But few of the solutions are machine specific and that won't solve my problem. And using RMAN, I need to try if its not machine / drive specific.
Please let me know if anyone knows how I can copy Database Creation Template from one machine to other so that I can create a template of my source database including data and structure and copy the template to other machine and create a new database with copied template.
hope i am thinking something practical and not just theoretical.
DBCA is something which needs to be explored for this option. please help me on this topic if anyone knows about the same.