ORA-27046: file size is not a multiple of logical block size

Answers were Sorted based on User's Feedback



ORA-27046: file size is not a multiple of logical block size..

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

ORA-27046: file size is not a multiple of logical block size..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-14322: DEFAULT partition already exists

1 Answers  


ORA-38726: Flashback database logging is not on.

1 Answers  


ORA-36157: (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.

1 Answers  


ORA-08321: scnmin: NOT IMPLEMENTED YET

1 Answers  


ORA-06040: NETDNT: invalid login (connect) string

1 Answers  


ORA-23341: user function required

1 Answers  


ORA-24421: OCISessionRelease cannot be used to release this session.

1 Answers  


SQL-02106: Inconsistent cursor cache. Invalid Oracle cursor number

1 Answers  


ORA-24342: unable to destroy a mutex

1 Answers  


ORA-28110: policy function or package string.string has error

1 Answers  


ORA-29521: referenced name string could not be found

1 Answers  


ORA-23301: mixed use of deferred rpc destination modes

1 Answers  


Categories