LFI-00125: Random access only allowed on fixed length record
files.



LFI-00125: Random access only allowed on fixed length record files...

Answer / guest

Cause: 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.

Action: 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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31447: cannot create change tables in the SYS schema

1 Answers  


NNL-00835: Average delete processing time: string

1 Answers  


QSM-02079: mv log must have ROWID

1 Answers  


ORA-24430: Null values for sqltext and key were specified.

1 Answers  


ORA-25119: LOGGING/NOLOGGING option already specified

1 Answers  






ORA-29326: SET COMPATIBILITY release number higher than string

1 Answers  


ORA-16631: Operation requires shutdown of database/instance "string"

1 Answers  


ORA-12400: invalid argument to facility error handling

1 Answers  


ORA-22370: incorrect usage of method string

1 Answers  


ORA-02065: illegal option for ALTER SYSTEM

1 Answers  


ORA-00977: duplicate auditing option

1 Answers  


PCC-00025: Undeclared indicator variable "string" at line number in file string

1 Answers  


Categories