I have Oracle 10g Express. How can I make a copy of my database and application?
I don't want to make a back up, I want to move my DB and application to another PC.
I have Oracle 10g Express. How can I make a copy of my database and application?
I don't want to make a back up, I want to move my DB and application to another PC.
First Install XE to another PC.
Then clone your database: Backing Up and Restoring the Database
Then transfer clone to another PC and restore the clone there.
This post may help you also: How to clone Oracle Express 10g Edition?
I haven't tried this but in theory you should be able to:
This should work for the database instance, but you may have trouble with the bundled web apps and network settings. In this case, if it's an option, you could rename your other PC to have the same name as your original PC...
You need to take a dump of the source database using DataPump export.
Then on the target PC install Oracle XE, and use DataPump import to import the dump taken from your source PC.
For details on the DataPump utility, please see the manual: http://docs.oracle.com/cd/E11882_01/server.112/e22490/part_dp.htm
There are also various tutorials for this utility on the web, just search for "Oracle DataPump".
Using RMAN (the "backup and recovery" tool recommended by others) is not a suitable tool for this kind of requirement. Doing a file level copy as suggested as well, will most probably not work either.
so what did guys is this: I took the back up from original DB deleted the ONLINELOG file from this bak up replaced the entire content of this back up with those on XE file on original source runned the restore manager and it went perfectly but could this make me any future errors since I messed with oracle files?