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-19727: cannot plug data [string] at level string into database running Oracle string
AMD-00152: Workspace "string" is not currently open.
SQL*Loader-00278: Incorrect file specification for parallel load.
ORA-22913: must specify table name for nested table column or attribute
RMAN-05005: point-in-time recovery is not allowed for re-created tablespace string
ORA-30933: Element 'string' may not appear at this point within parent 'string'
ORA-23493: "string" is not a new site for extension request "string"
ORA-07263: sptpa: kill error.
NNL-00293: Controller's trace level remains unchanged
ORA-02049: timeout: distributed transaction waiting for lock
ORA-22803: object type contains zero attributes
ORA-16717: clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed