[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