Ora-01301: Error Writing To File During Flat File Build (Doc ID 602149.1)

Last updated on JUNE 30, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3
This problem can occur on any platform.

Symptoms

You are trying to run logminer. As a part of this, you are trying to create a dictionary file using the following statement and getting errors:

SQL> set serveroutput on
SQL> EXECUTE SYS.DBMS_LOGMNR_D.BUILD('dictionary.ora', '/mapdbaapp/oracle/app/mapdbacomn/temp', SYS.DBMS_LOGMNR_D.STORE_IN_FLAT_FILE);
LogMnr Dictionary Procedure started
LogMnr Dictionary File Opened
In WRITE_DICTIONARY routine
ERROR -6502 ORA-06502: PL/SQL: numeric or value error: character string buffer
too small
Main handler in build_ff
ERROR -1301 ORA-01301: error writing to file during flat file build
ORA-06512:
at "SYS.DBMS_LOGMNR_INTERNAL", line 1675
ORA-06502: PL/SQL: numeric or value
error: character string buffer too small
Processed Rows = 0total =345791
BEGIN SYS.DBMS_LOGMNR_D.BUILD('dictionary.ora', '/mapdbaapp/oracle/app/mapdbacomn/temp', SYS.DBMS_LOGMNR_D.STORE_IN_FLAT_FILE); END;

*
ERROR at line 1:
ORA-01301: error writing to file during flat file build
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 1675
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 3474
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 3552
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 12
ORA-06512: at line 1




.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms