ORA-27046: file size is not a multiple of logical block size
- 2 Answers
- 20665 Views
- I also Faced
- E-Mail Answers
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 |
PCC-02351: illegal datatype equivalencing operation
DRG-10701: preference string.string already exists
PCC-02340: structure contains a bit field
ORA-06701: TLI Driver: incorrect number of bytes written
ORA-22161: type code [string] is not valid
NNL-00513: Shows or sets the server's auto-refresh failure retry interval
RMAN-20010: database incarnation not found
RMAN-08517: backup piece handle=string recid=string stamp=string
SQL*Loader-00470: table string does not have system generated OID
IMP-00012: invalid export mode (character) in header
ORA-09310: sclgt: error freeing latch
ORA-06932: CMX: error in local name
Oracle Errors 
