| URGENT! Pls. Help on Oracle Migration [message #60303] |
Fri, 30 January 2004 17:17  |
Dano Tang
Messages: 2
Registered: January 2004
|
Junior Member |
|
|
Dear All,
Pls. help me out on some Oralce migration issues...
Source
======
Oracle 7.3 on a Solaris 2.6 Unix box
Target
=====
Oracle 8i (8.1.7) on a Windows 2000 Server
Probem Description
================
I have done a full export from the Unix box using the attached Oracle export
utility; however, I also create a database on my W2K without making the same
tablespaces and datafiles as defined at the Unix. I transfer the export
file as binary mode to the W2K and do a full import to the
W2K............The problem is....the import starts to create the tablespaces
on the W2K to a Unix path like /u01/oracle/oradata/dbs/datuser.dbf ...and it
keeps to create all tablespaces with errors...of course, the importy utility
is not able to create it since it is a W2K not a Unix.
My question are
==============
1. Should I create the same tablespaces and datafiles on the W2K as the
same as those at Unix box before the import?
2. If Q(1) is yes, then should I do a FULL import to the W2K??
3. If Q(3) is no, then what should I do to migrate the Oracle to W2K???
Thanks a lot......................
Regards,
Dano
|
|
|
|
| Re: URGENT! Pls. Help on Oracle Migration [message #60311 is a reply to message #60303] |
Sun, 01 February 2004 02:25  |
Bola
Messages: 3
Registered: February 2004
|
Junior Member |
|
|
Your Answers are
==============
1. Should I create the same tablespaces and datafiles on the W2K as the
same as those at Unix box before the import?
YES, Pre-create all tablespaces on the W2K ORACLE database before starting the import.
2. If Q(1) is yes, then should I do a FULL import to the W2K??
Yes, Perform a FULL Database import into the new W2K database.
3. If Q(3) is no, then what should I do to migrate the Oracle to W2K??? Answer to Q(2) is YES.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
