SQL> create or replace
2 directory alert_dir
3 as
4 'E:\oracle\product\10.2.0\admin\bruce\bdump';

Directory created.

SQL> edit
Wrote file afiedt.buf
1 create table alert_log
2 (text_line varchar2(255))
3 organization external
4 (type oracle_loader default directory alert_dir
5 access parameters
6 (records delimited by newline
7 fields
8 )
9 location
10 (
11 'alert_bruce.log'
12 )
13* )
SQL> /

Table created.

ITPub博客

alert_log设置成external table

最新文章