Oracle external tables [message #291173] |
Thu, 03 January 2008 04:50  |
andreigann
Messages: 2 Registered: January 2008 Location: Romania
|
Junior Member |

|
|
Hello. I'm new in oracle and I have a problem at my work. I need to insert data from text files that are located on a shared folder from another computer. I've tried with external tables:
-- connect as sysadmin
create or replace directory xtern_data_dir as '\\myIP\dir\';
grant read,write on directory xtern_data_dir to and;
-- connect as and
DROP TABLE ext_tab;
CREATE TABLE ext_tab (
IDFURNIZOR NUMBER,
DENFURNIZOR VARCHAR2(40),
NRTELFURNIZOR VARCHAR2(14),
EMAILFURNIZOR VARCHAR2(30))
ORGANIZATION EXTERNAL (
TYPE oracle_loader
DEFAULT DIRECTORY xtern_data_dir
ACCESS PARAMETERS (
RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY ';'
MISSING FIELD VALUES ARE NULL
)
LOCATION ('test.txt')
)
PARALLEL
REJECT LIMIT 0;
If I execute
select * from ext_tab;
sql throws the next exception
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04063: unable to open log file EXT_TAB_1780_1392.log
OS error The data is invalid.
ORA-06512: at "SYS.ORACLE_LOADER", line 19
Any ideea why?
If you could give me an alternative to external tables if this doesn't work.
The user where the oracle service is running has adminstrative rights and the shared folder have Full Access. Thanks.
(Sorry about my english)
|
|
|
|
|
|