| external table error [message #556988] |
Thu, 07 June 2012 22:48  |
 |
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
