My Oracle Support Banner

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

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
  Cause
  Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

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