FAQ
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: 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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.com

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).

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 3 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedMar 1, '02 at 8:43a
activeMar 1, '02 at 7:28p
posts3
users2
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase