Large File Issues (2GB+) when Using Export (EXP-2 EXP-15) Import (IMP-2 IMP-21) Or SQL*Loader
(Doc ID 30528.1)
Last updated on NOVEMBER 27, 2019
Applies to:Oracle Database Cloud Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
***Checked for relevance on 03-APR-2012***
This article provides details about the restriction of older Oracle Database Utilities that prevent working with files >2GB. The article also provides the available workarounds, like the usage of a named pipe or exporting to tape.
The article is primarily intended for the Database Administrator of the Oracle7, and Oracle8 database, but can also be used for Oracle8i, Oracle9i, Oracle10g and Oracle11g databases.
The steps provided in this article do *NOT* apply to the export and import with the new Export and Import DataPump utilties (expdp and impdp). These utilities do not support the usage of named pipes. For details, see also <Note 276521.1> Oracle10g Export/Import DataPump Does Not Work with Tapes or UNIX Named Pipes.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!