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 |
ORA-38750: FLASHBACK DATABASE may not be performed using a dispatcher.
ORA-16035: missing required keyword string
ORA-14251: Specified subpartition does not exist
ORA-22306: type "string"."string" already exists
TNS-04079: Cannot administer Oracle Connection Manager with no CMAN.ORA, and port = number.
SQL*Loader-00101: Invalid argument for username/password
ORA-32141: get method does not match the type of the parameter
ORA-23423: job number string is not positive
ORA-12441: policy string already exists
TNS-04044: Specified gateways do not exist.
ORA-38740: Usable blocks value string is not valid.
ORA-22330: cannot alter a type that is not valid