How to fix the Oracle error LFI-00123: Cannot access file Sequentially and Randomly.?

In this post, you’ll learn more about the Oracle ErrorLFI-00123: Cannot access file Sequentially and Randomly. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

LFI-00123: Cannot access file Sequentially and Randomly.

Reason for the Error LFI-00123: Cannot access file Sequentially and Randomly.

Both the LFILFA_SEQ (sequential) and LFILFA_RANDOM (random) flags were specified during the file object creation. This is not allowed. Only one of the two may be specified.

How to fix the Error LFI-00123: Cannot access file Sequentially and Randomly. ?

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

Choose how you wish to access the file. If you choose random you can still access sequentially by just not using the repositioning functions.