My Oracle Support Banner

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

Last updated on SEPTEMBER 24, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to 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('<DICTONARY_FILENAME>', '<DICTIONARY_LOCATION>', 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('<DICTONARY_FILENAME>', '<DICTIONARY_LOCATION>', 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




.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.