Home » Infrastructure » Linux » external table error
external table error [message #556988] Thu, 07 June 2012 22:48 Go to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
i create the external table. it gives me following error.

SQL> SELECT *
2 FROM countries_ext
3 ORDER BY country_name;
SELECT *
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file Countries1.txt in EXT_TABLES not found
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1

SQL>
i check on the google this error due to the load files have not been saved in the appropriate directory.
i saved the load directory in location CREATE OR REPLACE DIRECTORY ext_tab_data AS '/data'; (that is in data location).
please help me to know what is appropriate lacation to save the load file (Countries1.txt file).

regards
pritesh ranjan
Re: external table error [message #556990 is a reply to message #556988] Thu, 07 June 2012 23:28 Go to previous messageGo to next message
Michel Cadot
Messages: 59422
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ The directory must be on the database server
2/ Oracle OS account must have the privileges to access the directory and file

Regards
Michel
Re: external table error [message #556992 is a reply to message #556990] Fri, 08 June 2012 00:05 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
thanks michel to give me your important time. i just solve this problem.

thanks & regards
pritesh ranjan
Re: external table error [message #556998 is a reply to message #556992] Fri, 08 June 2012 01:19 Go to previous messageGo to next message
Michel Cadot
Messages: 59422
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i just solve this problem.


Which was?

Regards
Michel
Re: external table error [message #557083 is a reply to message #556998] Fri, 08 June 2012 13:09 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
that is maintain above.

regards
pritesh ranjan
Re: external table error [message #557085 is a reply to message #557083] Fri, 08 June 2012 13:11 Go to previous messageGo to next message
Michel Cadot
Messages: 59422
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I mean what was the problem that causes the error and what was the solution.

Regards
Michel
Re: external table error [message #557086 is a reply to message #557085] Fri, 08 June 2012 13:16 Go to previous message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
i save the load file in directory location and also give the read and write permission to the load file.

regards
pritesh ranjan
Previous Topic: Default tablespaces in ORACLE
Next Topic: ORA 01261 and 01262
Goto Forum:
  


Current Time: Thu Oct 23 03:07:28 CDT 2014

Total time taken to generate the page: 0.22783 seconds