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-22162: element at index [string] has been previously deleted
ORA-32332: cannot refresh materialized view "string"."string" as type evolution has occured
NNL-00576: list_delegated: list all delegated domains in the region or subtree
NID-00106: LOGIN to target database failed with Oracle error: string
QSM-02073: non-primary key RepAPI mv is not fast refreshable
ORA-31078: error in SQL mapping information
ORA-29365: parameters string and string cannot both be set
PCC-02326: illegal structure reference operation
ORA-07237: slemcl: invalid file handle, seals do not match.
ORA-16075: standby database destination mismatch
ORA-01933: cannot create a stored object using privileges from a role
ORA-26025: SKIP_INDEX_MAINTENANCE option requested