| URGENT! Pls. Help on Oracle Migration [message #73082] |
Fri, 30 January 2004 17:19  |
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 #73132 is a reply to message #73082] |
Wed, 11 February 2004 05:03  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Answers to your questions:
1) Yes, you need to pre-create all the tablespaces (exactly as on your SUN system). Nevertheless, your files can have different names, locations and sizes.
2) Yes, why not. You will get errors on the CREATE TABLESPACE... statements, but you may ignore those.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
