Hi,
I have a problem with migrating our ORACLE DEV database to UAT environment.

Scenario:

DEV server setup:

OS: windows 2003 (no service pack)
RDBMS: ORACLE 10g Enterprise (10.1.0.2) with spatial
Database name: ora_dev
Local C: drive for OS
Local H: drive with RAID 5 setup

UAT server setup:

OS: Windows 2003 (no service pack)
RDBMS: ORACLE 10g Enterprise (10.1.0.2) with spatial
Database name: ora_uat
Local C: drive for OS
Local H: drive with RAID 5
SAN connected I: and J: drives

I was able to successfully install oracle 10g on DEV server and get the developers to work on it. A few new table spaces were created by developers on the DEV server.

I need to migrate, the ora_dev database to the UAT database (ora_uat)

What is the easiest method to migrate the complete ora_dev database to UAT?
Or should I only migrate the newly created table spaces to the ora_uat database?

If so how can I do this?
I had problems having different database names in the DEV and UAT environments.

Thanks in advanced

Regards

NuwanK