Oracle Error LFI-00123: Cannot access file Sequentially and Randomly.

Oracle Error Message

LFI-00123: Cannot access file Sequentially and Randomly.

Reason for the Error

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.

Solution

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

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...