How to fix the Oracle error KUP-04097: RECORDS clause specified without a record format?

In this post, you’ll learn more about the Oracle ErrorKUP-04097: RECORDS clause specified without a record format with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

KUP-04097: RECORDS clause specified without a record format

Reason for the Error KUP-04097: RECORDS clause specified without a record format

The RECORDS clause was part of the external table access parameters but no record format type was provided.

How to fix the Error KUP-04097: RECORDS clause specified without a record format ?

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

If the RECORDS clause is used, then it must be followed by one of the VARIABLE, FIXED, or DELIMITED BY clauses.