Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-27046: file size is not a multiple of logical block size
- 2 Answers
- 21084 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 |
ORA-09818: Number is too large
NNC-00421: invalid modification directive string, must be between string and string
NNL-00961: Cache checkpoints: number
ORA-02294: cannot enable (string.string) - constraint changed during validation
ORA-09801: Unable to get user ID from connection
ORA-16154: suspect attribute: string
ORA-24084: DBLINK name in address field of agent string is not unique within the first 24 bytes
ORA-14317: cannot drop the last value of partition
ORA-14620: DEFAULT subpartition already exists
DRG-12213: cannot create/drop section group or sections for other user
ORA-01858: a non-numeric character was found where a numeric was expected
DRG-13306: 'len' attribute value must be in the range string..string, at line string
Oracle Errors 
