ORA-27046: file size is not a multiple of logical block size

Answers were Sorted based on User's Feedback



ORA-27046: file size is not a multiple of logical block size..

Answer / guest

Cause: file size as indicated by stat is not correct,
additional information indicates which function encountered
the error

Action: verify that the file has not been overwritten or
truncated

Please add more information about this Error

Is This Answer Correct ?    3 Yes 0 No

ORA-27046: file size is not a multiple of logical block size..

Answer / sarvesh chaurasia

ERROR at line 1:
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
Recreate a binary SPFILE from an old init.ora, if any exists:

SQL> create spfile from pfile='initservu.ora';
File created.


Here initservu.ora
servu is a ORACLE_SID name .

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-02030: reduced precision specified for prebuilt mv

1 Answers  


SQL*Loader-00432: converted data too large

1 Answers  


ORA-14192: cannot modify physical index attributes of a Hash index partition

1 Answers  


ORA-24790: cannot mix OCI_TRANS_RESUME and transaction isolation flags

1 Answers  


PLS-00626: partitioned/clustered/ordered parameter must be a function argument

1 Answers  






ORA-21605: property [string] is not a property of value instances

1 Answers  


ORA-12445: cannot change HIDDEN property of column

1 Answers  


ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

2 Answers  


TNS-01303: ns main err code: number

1 Answers  


RMAN-08504: input archive log thread=string sequence=string recid=string stamp=string

2 Answers  


DRG-10823: invalid query name

1 Answers  


ORA-27503: IPC error attempting to cancel request

1 Answers  


Categories