ORA-13462: invalid blocking specification

Cause : The specified blocking configuration was invalid.

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

Block size must always be a power of 2.

update : 27-05-2017
ORA-13462

ORA-13462 - invalid blocking specification
ORA-13462 - invalid blocking specification

  • ora-16533 : inconsistent Data Guard broker state
  • ora-13800 : concurrent DDL failure on SQL repository objects
  • ora-02473 : Error while evaluating the cluster's hash expression.
  • ora-09938 : Save of signal handlers failed.
  • ora-25296 : Queue Table string has a buffered queue string
  • ora-14038 : GLOBAL partitioned index must be prefixed
  • ora-01539 : tablespace 'string' is not online
  • ora-30046 : Undo tablespace string not found in control file.
  • ora-16236 : Logical Standby metadata operation in progress
  • ora-09340 : Specified ORACLE_SID is either invalid or too long
  • ora-28055 : the password will expire within string days
  • ora-29831 : operator binding not found
  • ora-06596 : unsupported LOB operation in RPC call
  • ora-19809 : limit exceeded for recovery files
  • ora-14055 : keyword REBUILD in ALTER INDEX REBUILD must immediately follow
  • ora-27035 : logical block size is invalid
  • ora-14097 : column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-19122 : unsupported XQuery declaration
  • ora-02220 : invalid MINEXTENTS storage option value
  • ora-06250 : NETNTT: cannot allocate send and receive buffers
  • ora-38724 : Invalid option to the FLASHBACK DATABASE command.
  • ora-13200 : internal error [string] in spatial indexing.
  • ora-09200 : sfccf: error creating file
  • ora-09825 : Unable to disable allowmacaccess privilege.
  • ora-14296 : Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-01516 : nonexistent log file, datafile, or tempfile "string"
  • ora-29387 : no top-plans found in the pending area
  • ora-22318 : input type is not an array type
  • ora-35952 : (XSSPFC01) The string dimension workspace object and the string dimension workspace object must have the same number of values in status for SPFCEXEC method number.
  • ora-01868 : the leading precision of the interval is too small
  • 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.