| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to transfer a database from Solaris to W2K
Use the FILE= and FILESIZE= option to create multiple dump files from the
export. You can size them less than 2GB as you mentioned. FTP those in
binary mode to the target server. Use imp FILE= option with the file names
in the same sequence as in exp. And you should be fine.
Test this process to exp/imp a table or two to get acquainted with it.
I have done this across UNIX servers without any issues.
HTH,
-----Original Message-----
Sent: Friday, March 01, 2002 2:43 AM
To: Multiple recipients of list ORACLE-L
Hi,
we have to move database +data from Sun + Oracle 8.1.6 SE for Solaris (data
size is app 3-4Gb)
to Intel Xeon + Windows 2000 ADV Srv + Oracle 8.1.6 or 8.1.7.3 EE for W2K.
(app 60-70 user)
we are planning , install new server OS+ Database, create user, tablespace
...etc
and with export old system to import new system.
But, export size is problem . i think, export datafile must be divided and
less then 2Gb ,
ok. we'll check the export-import help. but we didn't try before this. we'll
do it at this weekend,
please help me detailed about how should we export and import
and add any ideas helps.
thank you.
E.Onder Kokturk
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: E.Onder Kokturk
INET: kokturk_at_egenet.com.tr
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Mar 01 2002 - 07:48:22 CST
 |
 |