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 : 26-04-2017

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

  • ora-16133 : Datafile string has incorrect terminal recovery stamp.
  • ora-02854 : Invalid number of request buffers
  • ora-23339 : duplicate conflict resolution information
  • ora-31433 : subscriber view does not exist
  • ora-14055 : keyword REBUILD in ALTER INDEX REBUILD must immediately follow
  • ora-26697 : LCR contains extra column 'string'
  • ora-16811 : apply instance not recorded by the Data Guard broker
  • ora-06313 : IPA: Shared memory failed to initialise
  • ora-23409 : could not find an unused refresh group number
  • ora-13915 : Critical byte based free space threshold value is greater than warning threshold value.
  • ora-32341 : The EXPLAIN_MVIEW facility failed to explain the materialized view "string"."string"
  • ora-36668 : (XSDPART06) string is not a legal RANGE partition.
  • ora-01619 : thread string is mounted by another instance
  • ora-16021 : session string destination cannot be the same as session string destination
  • ora-13710 : Parameter "string" must have a higher value than parameter "string". The values supplied were "string" and "string" respectively.
  • ora-29315 : tablespace 'string' has been recreated
  • ora-00349 : failure obtaining block size for 'string'
  • ora-31432 : invalid source table
  • ora-13484 : the file format and/or compression type is not supported
  • ora-02049 : timeout: distributed transaction waiting for lock
  • ora-13009 : the specified date string is invalid
  • ora-29300 : ORACLE error, tablespace point-in-time recovery
  • ora-12539 : TNS:buffer over- or under-flow
  • ora-36874 : (XSTFDSC04) Expression string cannot be used to define a column in a LIMITMAP.
  • ora-13040 : failed to subdivide tile
  • ora-06816 : TLI Driver: could not set the SPX SAP address
  • ora-10930 : trace name context forever
  • ora-12034 : materialized view log on "string"."string" younger than last refresh
  • ora-38412 : Expression set column string does not exist.
  • ora-15001 : diskgroup "string" does not exist or is not mounted
  • 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.