-
Oracle 10g database migration on windows 2003
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|