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, - Kirti -----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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
