ORA-13412: invalid scale parameter

Cause : The scale parameter was invalid.

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

Check the documentation, and make sure the scale parameter is correct.

update : 30-04-2017

ORA-13412 - invalid scale parameter
ORA-13412 - invalid scale parameter

  • ora-02196 : PERMANENT/TEMPORARY option already specified
  • ora-28140 : Invalid column specified
  • ora-06565 : cannot execute string from within stored procedure
  • ora-02401 : cannot EXPLAIN view owned by another user
  • ora-36762 : (XSLANGDM02) You cannot modify the string property of %J because analytic workspace string is attached in MULTI mode.
  • ora-26060 : Can not convert type identifier for column string
  • ora-13708 : Some snapshots in the range [string, string] were purged before the analysis was complete.
  • ora-36974 : (XSRELTBL14) workspace object is not a BOOLEAN variable dimensioned by all the dimensions of the hierarchy.
  • ora-24807 : LOB form mismatch
  • ora-01534 : rollback segment 'string' doesn't exist
  • ora-38104 : Columns referenced in the ON Clause cannot be updated: string
  • ora-02876 : smpini: Unable to attach to shared memory for PGA
  • ora-19802 : cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE
  • ora-19668 : cannot do full restore of datafile string
  • ora-13841 : SQL profile named string already exists for a different signature/category pair
  • ora-06702 : TLI Driver: cannot allocate context area
  • ora-01566 : file specified more than once in ALTER DATABASE
  • ora-01107 : database must be mounted for media recovery
  • ora-14174 : only a may follow COALESCE PARTITION|SUBPARTITION
  • ora-04062 : %s of string has been changed
  • ora-12921 : database is not in force logging mode
  • ora-22319 : type attribute information altered in ALTER TYPE
  • ora-14003 : GLOBAL clause contradicts previosly specified LOCAL clause
  • ora-01910 : TABLES keyword expected
  • ora-02269 : key column cannot be of LONG datatype
  • ora-06401 : NETCMN: invalid driver designator
  • ora-14004 : missing PARTITION keyword
  • ora-02878 : sou2o: Variable smpdidini overwritten
  • ora-13853 : Tracing for service (module/action) string is already enabled
  • ora-29807 : specified operator does not exist
  • 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.