|Error while accessing External tables [message #188544]
||Sat, 19 August 2006 04:36
Registered: January 2006
I created external table with a sampleff.txt file. but when I am trying to access the table (select * from ext_table_test) I am getting some errors like:|
ORA-29913: error in executing ODCIEXTTABLEOPEN call out
ORA-29400: unable to open log file EXT_TABLE_TEST_2183202.log
OS error No such file or directory
ORA-06512: at "SYS.ORACLE_LOADER", line 19
Can you please help me out?
Here is how I created and oracle directory and external table
Created a directory called gas_Ext_dir in the path with the command as shown
below from (DFPROT uer)
CREATE or REPLACE DIRECTORY GAS_EXT_DIR as '/u11/app/dfprot/gas_data';
Then gave grants to read and write to the user dfprotd on the directory
grant read, write on directory gas_ext_dir to dfprotd;
I placed a sample flat file named sampleff.txt in the directory gas_ext_dir
( '/u11/app/dfprot/gas_data/gas_Ext_dir/sampleff.txt' )
Data in sampleff.txt is
Created an external table as below.
create table ext_table_test (
default directory gas_ext_dir
access parameters (
records delimited by newline
fields terminated by ','
missing field values are null
Table was created with no errors.
All the permissions and grants are correct, but still getting some errors.
Any help would be very usefull.