Export Datapump to Null Device Getting ORA-31693 ORA-31643 ORA-19510 ORA-27042
(Doc ID 549273.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 06-Aug-2014***
Trying to do a DataPump export to a directory created on null device and getting errors like the following example:
1) DataPump directory was created like below:
SQL> GRANT read, write ON datapump TO system;
export.dmp is a symbolic link to null device:
SQL> !ls -l /oracle/GP2/saptrace/datapump/exportdp.dmp
-> lrwxrwxrwx 1 oragp2 dba 9 Jan 14 08:54
/oracle/GP2/saptrace/datapump/exportdp.dmp -> /dev/null
2) Trying to export to that directory gives errors like:
ORA-31643: unable to close dump file "/oracle/GP2/saptrace/datapump/exportdp.dmp"
ORA-19510: failed to set size of 29272 blocks for file
ORA-27042: not enough space on raw partition to fullfill request
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