OraFAQ Forum: Server Utilities » EXTERNAL TABLES reading from application server NOT db server

Home » RDBMS Server » Server Utilities » EXTERNAL TABLES reading from application server NOT db server (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

EXTERNAL TABLES reading from application server NOT db server [message #324382]

Mon, 02 June 2008 04:43

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?

Report message to a moderator

Re: EXTERNAL TABLES reading from application server NOT db server [message #324396 is a reply to message #324382]

Mon, 02 June 2008 05:25

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: EXTERNAL TABLES reading from application server NOT db server [message #324407 is a reply to message #324396]

Mon, 02 June 2008 06:37

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

Report message to a moderator

Re: EXTERNAL TABLES reading from application server NOT db server [message #324416 is a reply to message #324407]

Mon, 02 June 2008 07:16

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 12:05:28 CDT 2025