ORA-27046: file size is not a multiple of logical block size
Answers were Sorted based on User's Feedback
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 |
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 |
QSM-02030: reduced precision specified for prebuilt mv
SQL*Loader-00432: converted data too large
ORA-14192: cannot modify physical index attributes of a Hash index partition
ORA-24790: cannot mix OCI_TRANS_RESUME and transaction isolation flags
PLS-00626: partitioned/clustered/ordered parameter must be a function argument
ORA-21605: property [string] is not a property of value instances
ORA-12445: cannot change HIDDEN property of column
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
TNS-01303: ns main err code: number
RMAN-08504: input archive log thread=string sequence=string recid=string stamp=string
DRG-10823: invalid query name
ORA-27503: IPC error attempting to cancel request