I use the Scott user to create the directory, and granted the permissions:
SQL> The CREATE OR REPLACE DIRECTORY DUMP_DIR AS '/oradata exterltab';

After creating the external table:
[oracle @ TTT exterltab] $vi student. Data
@ # $10001 kerry @ # $28 male @ # $@ # $1
@ # $10002 Jimmy @ # $22 male @ # $@ # $1
@ # $Ken @ # $10003 male @ # $21 @ # $1
@ # $10004 merry @ # $femal @ # $20 @ # $1

The CREATE TABLE EXTER_TEST
(
ID NUMBER (5),
The NAME VARCHAR (12),
SEX VARCHAR (8),
The AGE NUMBER (3),
The GRADE NUMBER (1)
) ORGANIZATION EXTERNAL
(
Type oracle_loader
The default directory dump_dir
Access the parameters
(
Records delimited by newline
Fields terminated by a '@ # $'
)
The location (' student. Data)
);

The last access to external table data
Select * from exter_test

The error is as follows:
The ERROR at line 1:
ORA - 29913: the error in executing ODCIEXTTABLEOPEN callout
ORA - 29400: data cartridge error
Error opening the file/oradata exterltab/EXTER_TEST_4525 log


Can you tell me how to solve?

CodePudding user response:

Confirm the correct
Confirm that the user has access to the directory

CodePudding user response:

Ls -l once, see if files have r permissions;