oracle解析文本文件

oracle解析大数据量大文本文件。eg:log

            利用oracle外部表解析大文本文件

            create or replace directory error_log as 'E:\lx\error';

            create table t_error_log(text varchar2(4000))
                 organization external(
                   type oracle_loader
                  default directory error_log
                 access parameters(
                       records delimited by 0x'0A'
                       badfile 'error_log.bad'
                       logfile 'error_log.log'
                       readsize 10485760
                        fields terminated by 0x'0A'
                          MISSING FIELD VALUES ARE null
                 )
                location('error.log')
             )
             reject limit unlimited;

相关推荐