ORA-39001 ORA-39000 ORA-31641 ORA-27040

ORA-39001 ORA-39000 ORA-31641 ORA-27040

Taking table/schema dump gets failed using EXPDP with below error:

Problem:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/home/oracle/backupwk/mafsdb/expdat.dmp"

 

ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 22: Invalid argument

Cause:
If you export dump of tables/schema to a file system (tmpfs) which does not support O_DIRECT/SETALL
filesystemio_options parameter is set to O_DIRECT/SETALL and you export dump of tables/schema with expdp to a file system (tmpfs) which does not support O_DIRECT/SETALL

SOL:

connect / as sysdba

sql>show parameter filesystemio_options

NAME                                 TYPE        VALUE
———————————— ———– ——————————
filesystemio_options                 string      SETALL

sql>alter system set filesystemio_options=none scope=spfile;

–Bounce the database to take effect of parameter change:

sql> shu immediate

sql>startup

–Alter the filesystemio_option to none

sql> show parameter filesystemio_options

NAME                                 TYPE        VALUE
———————————— ———– ——————————
filesystemio_options                 string      none

–Now try to export dump using expdp, it will be successful.

Source:
Metadata Link:

DataPump Export (EXPDP) Received Error ORA-31641 (Doc ID 1330406.1)

You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply