SQL> create user Oracle identified by oracle;

用户已创建。

SQL> grant dba to oracle;

授权成功。

SQL> grant create any directory to oracle;

授权成功。

SQL> conn oracle/oracle
已连接。

SQL> select * from dba_directories;

OWNER DIRECTORY_NAME DIRECTORY_PATH
-------------------- ---------------------------------------- -------------------------------------------
--
SYS ADMIN_DIR C:ADEaime_vista_shiporacle/md/admin
SYS DATA_PUMP_DIR d:oracleproduct10.2.0adminorcldpdump
SYS BDUMP D:oracleproduct10.2.0adminorclbdump
SYS WORK_DIR C:ADEaime_vista_shiporacle/work

SQL> create table alert_log(text varchar2(400))
2 organization external (
3 type oracle_loader
4 default directory BDUMP
5 access parameters(
6 records delimited by newline
7 nobadfile
8 nodiscardfile
9 nologfile
10 )
11 location('alert_orcl.log')
12 )
13 reject limit unlimited
14 /

表已创建。

SQL> select * from alert_log where rownum