Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

help on export and import a large schema

Status
Not open for further replies.

xrchen

Technical User
Nov 13, 2000
1
US
i have a large schema, about 12G, oracle 8i on a NT box.
i need to import to oracle on a sun box.
is there any good way to do so?
thanks.
 
the export file itself should be platform independant.

If your sun os does not support files larger than 2gb then you will need to split the export file into several chunks use the FILESIZE param and multiple FILE entries eg file=(a,b,d,e,f)

ftp them in binary and you should be OK.

with that much data if possible pre-create the tables without indices and add them after
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top