Oracle Error KUP-04097: RECORDS clause specified without a record format

Oracle Error Message

KUP-04097: RECORDS clause specified without a record format

Reason for the Error

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

Solution

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