Hi,
Database: Oracle 12c EE 12.1.0.2.0-64bit running on Linux x86_64 OS
I'm getting OS errors when I'm writing out External Table files from queries using the ORACLE_DATAPUMP driver
e.g. CREATE TABLE … ORGANIZATION EXTERNAL (TYPE ORACLE_DATAPUMP … LOCATION … PARALLEL 4 REJECT LIMIT 0 AS … SELECT <columns> from <tables> where … etc
My program is basically trying to extract data from a source system by querying various source tables and loading that data into External Table files using the ORACLE_DATAPUMP driver.
The code had been working fine for months but started falling over recently at different points in the process (i.e. different External Tables) with errors as follows:
First Error Type
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-19502: write error on file …. block number 514 (block size=4096)
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 13: Permission denied
Second Error Type
ORA-29913: error in executing ODCIEXTTABLECLOSE callout
ORA-31643: unable to close dump file ...
ORA-27052: unable to flush file data
Linux-x86_64 Error: 13: Permission denied
The DBA had a look at permissions and said everything looked fine?
Tablespace Encryption had been implemented around the time this started falling over so that's maybe more than just a coincidence
but before I suggest to the DBA to remove it temporarily, does anybody have any ideas as to what is the cause of this problem or have you seen something similar before?
Note, I got this same issue when I pointed to a different Oracle Directory and loaded less data so it doesn't appear to be space-related but I could be wrong.
I'm not a DBA or Sys Admin so I won't be able to access the Linux box myself but any suggestions are greatly appreciated.
Thanks.