Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

External table, From Client, directory visible on client and server, feasible ?

swapnil kambliNov 12 2013 — edited Nov 14 2013

Hi Guys,

My client wants to use external table method from client machine.

Oracle db version 11.2.0.3, client (sqlplus) version 11.2.0.1.0 ,OS AIX

The filesystem directory on which the csv file resides is made as database directory and it is visible/read-write on both servers.

OS user who is running create table has read - write access to this directory and the database user has read write to the database directory.

I can do the load from db server but not from the server where the client is installed.Gives below error.

ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
error opening file
/wload/ga5t/gpfs/app/Env10/oracle/oracleloaddirectory/EXT_PRICE_LIST_IMPORT_SC_1
_9044034.log

Any idea as to how it is happening? Is it feasible to do this when the db and os directory is visible on both client and db server?

Thanks,

swapnil

This post has been answered by swapnil kambli on Nov 14 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 12 2013

Added on Nov 12 2013

#client, #database-key-features, #export-import-sql-loader-external-tables, #table

11 comments

1,177 views