Home » SQL & PL/SQL » SQL & PL/SQL » using external tables
using external tables [message #297930] Mon, 04 February 2008 05:01 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In external table you have a parameter "default directory" which is not dependent on the OS.

Regards
Michel
Re: using external tables [message #297965 is a reply to message #297930] Mon, 04 February 2008 06:02 Go to previous messageGo to next message
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
Re: using external tables [message #297966 is a reply to message #297965] Mon, 04 February 2008 06:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
External table reads local files.

Regards
Michel
Re: using external tables [message #297969 is a reply to message #297966] Mon, 04 February 2008 06:09 Go to previous messageGo to next message
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
Re: using external tables [message #297970 is a reply to message #297969] Mon, 04 February 2008 06:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.
Local means local to the Oracle instance (database), on the same server.

Regards
Michel

[Updated on: Mon, 04 February 2008 06:16]

Report message to a moderator

Re: using external tables [message #297975 is a reply to message #297970] Mon, 04 February 2008 06:41 Go to previous messageGo to next message
shary
Messages: 15
Registered: May 2006
Location: KUWAIT
Junior Member

hi
is there is any other way out to achieve this
Re: using external tables [message #297981 is a reply to message #297975] Mon, 04 February 2008 06:57 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Transfert the file inside database server.

Regards
Michel
Previous Topic: utl_file not as expected
Next Topic: Acess a remote database without database link please help
Goto Forum:
  


Current Time: Wed Dec 07 16:14:32 CST 2016

Total time taken to generate the page: 0.09172 seconds