How to fix the Oracle error LFI-00127: No Record Format was specified, default is variable.?

In this post, you’ll learn more about the Oracle ErrorLFI-00127: No Record Format was specified, default is variable. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

LFI-00127: No Record Format was specified, default is variable.

Reason for the Error LFI-00127: No Record Format was specified, default is variable.

Neither LFILRF_FIXED (fixed) or LFILRF_VAR (variable) were specified for record format. One of the two must be specified for each file.

How to fix the Error LFI-00127: No Record Format was specified, default is variable. ?

You can fix this error in Oracle by following the below steps

The default is LFILRF_VAR, but this should be explicitly set during file object creation.