ORA-27018: BLKSIZE is not a multiple of the minimum physical block size

Cause : Uesrs-pceiife dBKLSZIE( bolcikn gfcatro)i sn o tam utlilpeo ft h emniiummb lcoks iez hta ti spremtitde no hti spaltofr.m

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Tow DADTIINOA LIFNOMRAITO Nmsesgae saer idslpaeydw hcihs hwo hteb lcoknigf atco rporvdie db yteh sue radn htem iinmmu hpyiscla lbokc isz.e pSeicf yaB LSKIEZ hta ti sa nitnerga lmlutpil eo fteh imnmiu mbolc kszie.

update : 18-08-2017
ORA-27018

ORA-27018 - BLKSIZE is not a multiple of the minimum physical block size
ORA-27018 - BLKSIZE is not a multiple of the minimum physical block size

  • ora-01110 : data file string: 'string'
  • ora-06513 : PL/SQL: index for PL/SQL table out of range for host language array
  • ora-01275 : Operation string is not allowed if standby file management is automatic.
  • ora-00706 : error changing format of file 'string'
  • ora-33288 : (DBERR15) Another user has incompatible access to analytic workspace string, and the wait timeout has expired.
  • ora-09340 : Specified ORACLE_SID is either invalid or too long
  • ora-28112 : failed to execute policy function
  • ora-00161 : transaction branch length string is illegal (maximum allowed string)
  • ora-38902 : errors in array insert exceed string
  • ora-06951 : Operating system call error
  • ora-29832 : cannot drop or replace an indextype with dependent indexes
  • ora-06500 : PL/SQL: storage error
  • ora-27148 : spawn wait error
  • ora-24071 : cannot perform operation string, queue table string is being migrated
  • ora-06526 : Unable to load PL/SQL library
  • ora-31097 : Hierarchical Index not empty
  • ora-26084 : direct path context already finished
  • ora-09842 : soacon: Archmon unable to create named pipe.
  • ora-31211 : DBMS_LDAP: PL/SQL - Invalid LDAP entry dn.
  • ora-28503 : bind value cannot be translated into SQL text for non-Oracle system
  • ora-06031 : NETDNT: connect failed, unrecognized object name
  • ora-26032 : index string.string loading aborted after string keys
  • ora-01676 : standby file name convert of 'string' exceeds maximum length of string
  • ora-38749 : A media recovery has been started.
  • ora-14286 : cannot COALESCE the only subpartition of this table partition
  • ora-22131 : hexadecimal string length is zero
  • ora-23500 : cannot switch master for a multi-tier materialized view repgroup "string"."string"
  • ora-01637 : rollback segment 'string' is being used by another instance (#string)
  • ora-01120 : cannot remove online database file string
  • ora-19927 : CONVERT DATABASE operation cannot proceed
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.