ORA-13003: the specified range for a dimension is invalid

Cause : The speicfied ragne for ad imensio nis invaild.

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

Make suer that teh lower obund (lb )is lesst han theu pper bonud (ub).

update : 28-05-2017

ORA-13003 - the specified range for a dimension is invalid
ORA-13003 - the specified range for a dimension is invalid

  • ora-01612 : instance string (thread string) is already enabled
  • ora-23378 : connection qualifier "string" is not valid for object group "string"."string"
  • ora-27209 : syntax error in device PARMS - unknown keyword or missing =
  • ora-32822 : subscriber string is marked for removal
  • ora-12731 : invalid collation class in regular expression
  • ora-06932 : CMX: error in local name
  • ora-19631 : archivelog record contains no file name
  • ora-06033 : NETDNT: connect failed, partner rejected connection
  • ora-29950 : warning in the execution of ODCIINDEXMERGEPARTITION routine
  • ora-23495 : serial propagation can not be used for "string"
  • ora-09276 : All bequeath database links must be loopback database links
  • ora-00293 : control file out of sync with redo log
  • ora-14321 : cannot add/drop values to DEFAULT partition
  • ora-16180 : number processes specified for MAX_PARALLEL_SERVERS is too small
  • ora-25257 : consumer must be specified with a multi-consumer queue
  • ora-12354 : secondary object being dropped
  • ora-22329 : cannot alter a non-object type
  • ora-27066 : number of buffers in vector I/O exceeds maximum
  • ora-06562 : type of out argument must match type of column or bind variable
  • ora-24003 : Queue table index string inconsistent with queue table string
  • ora-33297 : (DBERR22) Analytic workspace string cannot be opened because it was last modified by an incompatible version of string.
  • ora-16063 : remote archival is enabled by another instance
  • ora-29890 : specified primary operator does not have an index context
  • ora-01763 : update or delete involves outer joined table
  • ora-02315 : incorrect number of arguments for default constructor
  • ora-06448 : ssvpstp: Failed with unexpected error number.
  • ora-36280 : (XSCGMDLAGG08) Valueset workspace object does not contain values of any dimension of the current model.
  • ora-19902 : incarnation key string not found
  • ora-01764 : new update value of join is not guaranteed to be unique
  • ora-07406 : slbtpd: invalid number.
  • 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.