| Error Messages [message #63090] |
Thu, 09 September 2004 00:04  |
Shakeel
Messages: 8
Registered: July 2003
|
Junior Member |
|
|
I have a database on my machine. Whenever I try to use the alter system command to try and change the cursor_sharing parameter, I get the following 2 errors:
ORA-27046
OSD-04000
Here is what each of these errors mean:
1) ORA-27046 file size is not a multiple of logical block size
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.
2) OSD-04000
Logical block size mismatch
Cause: The database block size specified in the initialization parameter file does not match the block size of the actual database files.
Action: Use matching logical block sizes.
What do I do? I don't want to drop the table and re-create it. I would like to work around it.
Please help out.
Thank you.
Shakeel.
:)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
