Home » RDBMS Server » Server Utilities » EXTERNAL TABLES reading from application server NOT db server (Oracle 10g)
EXTERNAL TABLES reading from application server NOT db server [message #324382] Mon, 02 June 2008 04:43 Go to next message
matspring
Messages: 11
Registered: May 2008
Location: UK
Junior Member
Hi

Can External Tables be used to read DAT files from the application server instead of the db server?

I'm trying this without success. DBA had advised me that the new directory path that I am using has be created to map to the app server, however when I select from my ex table I get the following error:

KUP-04040: file LDERVN.dat in [directory] not found

any one done this, that can help?
Re: EXTERNAL TABLES reading from application server NOT db server [message #324396 is a reply to message #324382] Mon, 02 June 2008 05:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can External Tables be used to read DAT files from the application server instead of the db server?

No.

Regards
Michel
Re: EXTERNAL TABLES reading from application server NOT db server [message #324407 is a reply to message #324396] Mon, 02 June 2008 06:37 Go to previous messageGo to next message
matspring
Messages: 11
Registered: May 2008
Location: UK
Junior Member
Can you please explain why not? It seems a reasonable thing to want to do!

Many thanks
Re: EXTERNAL TABLES reading from application server NOT db server [message #324416 is a reply to message #324407] Mon, 02 June 2008 07:16 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because it is as it.
The PL/SQL engine run on the server and sees only local files. Although you can use NFS files, it is not recommended and Oracle never supported Windows network drives.

Regards
Michel
Previous Topic: Performance Issue in exporting Tables in Oracle 10g to take Backup
Next Topic: DataPump Import
Goto Forum:
  


Current Time: Mon Dec 05 20:58:42 CST 2016

Total time taken to generate the page: 0.10751 seconds