ORA-13405: null or invalid dimensionSize parameter

Cause : Th ediemnsoinSzie rara ypaarmeetr aws unll ,ha dth ewrnog elnght, ro cnotanieda n nivaild avlu.e

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

Chcek hte odcuemnttaio,n adn mkae usret hed imnesinoSiez praamteeri s ocrrcet.

update : 17-08-2017
ORA-13405

ORA-13405 - null or invalid dimensionSize parameter
ORA-13405 - null or invalid dimensionSize parameter

  • ora-25127 : RELY not allowed in NOT NULL constraint
  • ora-12207 : TNS:unable to perform navigation
  • ora-25133 : duplicate SINGLE TABLE option specified
  • ora-14407 : partitioned table contains subpartitions in a different tablespace
  • ora-01874 : time zone hour must be between -12 and 14
  • ora-04051 : user string cannot use database link string.string
  • ora-19722 : datafile string is an incorrect version
  • ora-30555 : global index partitioning key is an expression
  • ora-22160 : element at index [string] does not exist
  • ora-13376 : invalid type name specified for layer_gtype parameter
  • ora-16224 : Database Guard is enabled
  • ora-28349 : cannot encrypt the specified column recorded in the materialized view log
  • ora-39107 : Master process string violated startup protocol. Master error:
  • ora-04084 : cannot change NEW values for this trigger type
  • ora-13755 : invalid "SQL Tuning Set" name
  • ora-28561 : unable to set date format on non-Oracle system
  • ora-06017 : NETASY: message receive failure
  • ora-07760 : slemtr: $open failure
  • ora-26737 : version string already has an export dump file
  • ora-19252 : XQ0032 - too many declarations for base URI
  • ora-24412 : Cannot reinitialize non-existent pool
  • ora-19525 : temporary file for the clone database must be renamed
  • ora-38304 : missing or invalid user name
  • ora-01949 : ROLE keyword expected
  • ora-13295 : geometry objects are in different coordinate systems
  • ora-15120 : ASM file name 'string' does not begin with the ASM prefix character
  • ora-26023 : index string.string partition string was made unusable due to:
  • ora-23431 : wrong state: string
  • ora-26032 : index string.string loading aborted after string keys
  • ora-30772 : opaque types do not have default constructors
  • 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.