Oracle Error Message
LFI-00125: Random access only allowed on fixed length record files.
Reason for the Error
The LFILFA_RANDOM flag was specified on a file that was not organized into fixed-length records. Random access is only allowed on fixed-length record files.
Solution
Determine if the organization of your data needs to be in variable-length records and if you need to have random access to the file. If both conditions are true then you might need to buffer the entire file or enough of it to remove your need for random access. Another option is to close and rescan the file although this is not the optimal solution.
