oracle外部表kup-04023,查询外部表出现KUP-4040错误

[tingkun.yang@enmoteam2 ~]$ id

uid=505(tingkun.yang) gid=501(oinstall) groups=501(oinstall),502(dba)

[tingkun.yang@enmoteam2 ~]$ ps -ef|grep lgwr

oracle 1552 1 0 Sep07 ? 00:04:14 ora_lgwr_enmot2

505 28312 28185 0 22:52 pts/0 00:00:00 grep lgwr

[tingkun.yang@enmoteam2 ~]$ sqlplus olasuser/olasuser

SQL*Plus: Release 11.2.0.3.0 Production ON Sat Nov 24 22:53:06 2012

Copyright (c) 1982, 2011, Oracle. ALL rights reserved.

Connected TO:

Oracle DATABASE 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

WITH the Partitioning, OLAP, DATA Mining AND REAL Application Testing options

SQL> CREATE directory d_alert AS '/home/oracle/sqlldr';

Directory created.

SQL> CREATE TABLE t_alert

2 (text varchar2(4000))

3 organization external

4 (TYPE oracle_loader

5 DEFAULT directory d_alert

6 access parameters

7 (records delimited BY newline

8 FIELDS (text (1:255) CHAR))

9 location ('alert_enmot2.log'));

TABLE created.

SQL> SELECT * FROM t_alert WHERE rownum = 1;

SELECT * FROM t_alert WHERE rownum = 1

*

ERROR at line 1:

ORA-29913: error IN executing ODCIEXTTABLEOPEN callout

ORA-29400: DATA cartridge error

KUP-04040: file alert_enmot2.log IN D_ALERT NOT found

[tingkun.yang@enmoteam2 ~]$ id

uid=505(tingkun.yang) gid=501(oinstall) groups=501(oinstall),502(dba)

[tingkun.yang@enmoteam2 ~]$ ps -ef|grep lgwr

oracle 1552 1 0 Sep07 ? 00:04:14 ora_lgwr_enmot2

505 28312 28185 0 22:52 pts/0 00:00:00 grep lgwr

[tingkun.yang@enmoteam2 ~]$ sqlplus olasuser/olasuser

SQL*Plus: Release 11.2.0.3.0 Production on Sat Nov 24 22:53:06 2012

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create directory d_alert as '/home/oracle/sqlldr';

Directory created.

SQL> create table t_alert

2 (text varchar2(4000))

3 organization external

4 (type oracle_loader

5 default directory d_alert

6 access parameters

7 (records delimited by newline

8 fields (text (1:255) char))

9 location ('alert_enmot2.log'));

Table created.

SQL> select * from t_alert where rownum = 1;

select * from t_alert where rownum = 1

*

ERROR at line 1:

ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-29400: data cartridge error

KUP-04040: file alert_enmot2.log in D_ALERT not found