My Oracle Support Banner

When Attempting To Perform Data Pump Export, Getting ORA-19510 ORA-27039 'Additional information: 4' Errors (Doc ID 1927751.1)

Last updated on JULY 26, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

You are trying to perform a Data Pump export (exdp) and when attempting to perform a data pump export the following errors occur:

ORA-19510: failed to set size of 4294967295 blocks for file "<DIRECTORY_NAME>/<DUMPFILE_NAME>.dmp" (block size=4096)
ORA-27039: create file failed, file size limit reached
Additional information: 4
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 9721

 

You have verified that the oracle user does have the file size set to unlimited:

$ ulimit -a
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 7983
max locked memory       (kbytes, -l) 32
max memory size         (kbytes, -m) unlimited
open files                      (-n) 4096
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 32768
cpu time               (seconds, -t) unlimited
max user processes              (-u) 2047
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited

 

And confirmed that you can create a file to the directory location executing the 'dd' command as the oracle user


This completed creating a 4G file.


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


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