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 JANUARY 30, 2022
Applies to:
Oracle Database Cloud Service - Version N/A and laterOracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 8.1.5.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Generic UNIX
Purpose
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.
Scope
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.
Details
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |