Exporting database on oracle

Question

I have a DB on oracle on Windows Server 2003. How do I export it with all the data and put it into other Windows server?

Answer 1

Use RMAN to take a full backup. Then restore it on the new server.

See Clone using RMAN Article

Answer 2

You can use Oracle Data Pump to export and import database. Quote from documentation:

Oracle Data Pump is a feature of Oracle Database 11g Release 2 that enables very fast bulk data and metadata movement between Oracle databases.

Procedure is like this:

1. Export existing database using expdp utility
2. Install Oracle database server on new Windows server
3. Import database on new server using impdp utility

Check this link: Oracle Data Pump. There you will find complete documentation and examples how to use this utility.