根据TOM的提示,使用外部表来查看数据库的警告日志文件[@more@]conn system/manager
grant create any directory to scott;
grant drop any directory to scott;
conn scott/tiger
create or replace directory data_dir as 'D:oracleadmingswebbdump';
-- grant read,write on directory data_dir to scott ;
CREATE TABLE alert_log
(
text_line varchar2(255)
)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_LOADER
DEFAULT DIRECTORY DATA_DIR
ACCESS PARAMETERS
(
records delimited by newline
fields
REJECT ROWS WITH ALL NULL FIELDS
)
LOCATION
(
'alert_gsweb.log'
)
)
REJECT LIMIT unlimited
/
grant create any directory to scott;
grant drop any directory to scott;
conn scott/tiger
create or replace directory data_dir as 'D:oracleadmingswebbdump';
-- grant read,write on directory data_dir to scott ;
CREATE TABLE alert_log
(
text_line varchar2(255)
)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_LOADER
DEFAULT DIRECTORY DATA_DIR
ACCESS PARAMETERS
(
records delimited by newline
fields
REJECT ROWS WITH ALL NULL FIELDS
)
LOCATION
(
'alert_gsweb.log'
)
)
REJECT LIMIT unlimited
/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/271063/viewspace-909954/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
