[oracle 10g xe] copy 100% into another pc with exact same installation

[Jesus Angeles]

Hi db experts,

I am a developer. Can I ask your tips on the following:

I have 2 computers (hereby I will call PC1 and PC2) with this db mentioned, installed in exactly the same folder path on each computer (e.g. both are in 'c:/oraclexe/' on each computer).

I wish to delete entire PC2 installation folder '/oraclexe/' and copy the entire '/oraclexe/' folder from PC1.

Because PC1 is huge, I am wondering if there are files that I do not need to copy over to PC2.

I believe '/oraclexe/app/oracle/admin/XE/bdump/*' is one. I do not need to copy it over. Correct me if I am wrong.

Anything else that I do not need to copy?

I will appreciate it.

- j

[chris webster]

If you've already installed Oracle XE on both machines, then your software should be fine.

So if you want to copy your data, you can use one of Oracle's export/import tools: http://docs.oracle.com/cd/B25329_01/doc/admin.102/b25107/impexp.htm

This will create an output file in a known format, which you can copy to the new machine. It will also ensure that the data and other DB objects can be imported correctly into your target database.

Don't try copying Oracle's own files around, as you'll almost certainly screw things up. There are standard Oracle tools for exporting/importing data, so why not use them?