OraFAQ Forum: SQL & PL/SQL » using external tables

Home » SQL & PL/SQL » SQL & PL/SQL » using external tables

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

using external tables [message #297930]

Mon, 04 February 2008 05:01

shary
Messages: 15
Registered: May 2006
Location: KUWAIT

Junior Member

Hi Experts,
I just need some help regarding orcle 10g external tables.
I have oracle 10g installed in my laptop and i have tried to use external tables. i just need to know that is there is any way that if oracle 10g is in winxp and the text files is in unix machine (ip 10.42.3.3) path=/export/home/shary/numbers.txt.
i want to create an external table which will directly ready from the text file which is in the unix machine,so please kindly tell me that how i can do this using SQLPLUS.

[Updated on: Mon, 04 February 2008 05:13] by Moderator

Report message to a moderator

Re: using external tables [message #297937 is a reply to message #297930]

Mon, 04 February 2008 05:14

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

Senior Member
Account Moderator

In external table you have a parameter "default directory" which is not dependent on the OS.

Regards
Michel

Report message to a moderator

Re: using external tables [message #297965 is a reply to message #297930]

Mon, 04 February 2008 06:02

shary
Messages: 15
Registered: May 2006
Location: KUWAIT

Junior Member

hi
if you dont mind this is my path in unix path=/export/home/shary/numbers.txt. where is the text file and
the ip address of the unix machine is 10.40.3.3 so plese can you tell me the exact configuration that what need to be write while making the external table

Report message to a moderator

Re: using external tables [message #297966 is a reply to message #297965]

Mon, 04 February 2008 06:03

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

Senior Member
Account Moderator

External table reads local files.

Regards
Michel

Report message to a moderator

Re: using external tables [message #297969 is a reply to message #297966]

Mon, 04 February 2008 06:09

shary
Messages: 15
Registered: May 2006
Location: KUWAIT

Junior Member

hi
what exactly u mean by local files if the file is a text file and place in the unix system thet the external table cannot able to read it if the oracle is in windows xp

Report message to a moderator