| Error while accessing External tables [message #188544] |
Sat, 19 August 2006 04:36  |
rekha.battula
Messages: 7
Registered: January 2006
|
Junior Member |
|
|
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
gas_ext_dir
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
1,'one'
2,'two'
3,'three'
Created an external table as below.
create table ext_table_test (
col1 number(2),
col2 varchar2(20)
)
Organization external(
type oracle_loader
default directory gas_ext_dir
access parameters (
records delimited by newline
fields terminated by ','
missing field values are null
)
location ('sampleff.txt')
Table was created with no errors.
All the permissions and grants are correct, but still getting some errors.
Any help would be very usefull.
Regards,
Rekha
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
