My Oracle Support Banner

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 later
Oracle 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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.