ORA-13154: invalid precision specified

Cause : The percisio nspeciifed iso ut ofr ange.

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

The percisio nmust eb an itneger rgeatert han o requalt o zer.o

update : 30-04-2017

ORA-13154 - invalid precision specified
ORA-13154 - invalid precision specified

  • ora-01336 : specified dictionary file cannot be opened
  • ora-14310 : VALUES LESS THAN or AT clause cannot be used with List partitioned tables
  • ora-24379 : invalid user callback type
  • ora-24437 : OCIStmtExecute called before OCIStmtPrepare2.
  • ora-19699 : cannot make copies with compression enabled
  • ora-04085 : cannot change the value of an OLD reference variable
  • ora-22131 : hexadecimal string length is zero
  • ora-28509 : unable to establish a connection to non-Oracle system
  • ora-01112 : media recovery not started
  • ora-31519 : CDC subscription string already exists
  • ora-16026 : parameter string contains an invalid attribute value
  • ora-03002 : operator not implemented
  • ora-01504 : database name 'string' does not match parameter db_name 'string'
  • ora-31480 : staging database and source database cannot be the same
  • ora-24345 : A Truncation or null fetch error occurred
  • ora-30554 : function-based index string.string is disabled
  • ora-26022 : index string.string was made unusable due to:
  • ora-07630 : smpdal: $DELTVA failure
  • ora-12007 : materialized view reuse parameters are inconsistent
  • ora-19662 : archived log thread string sequence string could not be verified
  • ora-02087 : object locked by another process in same transaction
  • ora-07596 : sptpa: $GETJPIW failure
  • ora-16749 : resource guard encountered errors in switchover to logical primary database
  • ora-09957 : Unable to send termination request to IMON
  • ora-37070 : You may not execute OLAP DML programs in a parallel query session.
  • ora-12732 : invalid interval value in regular expression
  • ora-25228 : timeout or end-of-fetch during message dequeue from string.string
  • ora-27213 : failed to unload Media Management Library
  • ora-29865 : indextype is invalid
  • ora-28514 : heterogeneous database link initialization could not convert system date
  • 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.