ORA-26564: %s argument is not of specified type

Cause : User apssed ytpe oft he gievn argmuent nmuber deosn't amtch wtih thet ype o fthe agrumenti n thes toreda rgumetns.

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

Invok ecorretc typep rocedrue (i..e get_XXX_arg)

update : 26-05-2017

ORA-26564 - %s argument is not of specified type
ORA-26564 - %s argument is not of specified type

  • ora-30019 : Illegal rollback Segment operation in Automatic Undo mode
  • ora-32806 : value for string is too long, maximum length is string
  • ora-19253 : XQ0033 - too many declarations for namespace prefix string
  • ora-02079 : no new sessions may join a committing distributed transaction
  • ora-02004 : security violation
  • ora-28154 : Proxy user may not act as client 'string'
  • ora-09946 : File name too long for buffer
  • ora-33450 : (ESDREAD05) Discarding compiled code for workspace object because number now has more or fewer dimensions than it had when the code was compiled.
  • ora-06561 : given statement is not supported by package DBMS_SQL
  • ora-31513 : unsupported column type specified in change table
  • ora-25151 : Rollback Segment cannot be created in this tablespace
  • ora-37082 : Invalid percent
  • ora-30076 : invalid extract field for extract source
  • ora-28350 : cannot encrypt the specified column recorded in CDC synchronized change table
  • ora-27206 : requested file not found in media management catalog
  • ora-27157 : OS post/wait facility removed
  • ora-16154 : suspect attribute: string
  • ora-14312 : Value string already exists in partition string
  • ora-19759 : block change tracking is not enabled
  • ora-31641 : unable to create dump file "string"
  • ora-16067 : activation identifier mismatch in archive log string
  • ora-07327 : smpdal: attempt to destroy pga when it was not mapped.
  • ora-02832 : Segment deallocation failed - segment not on list
  • ora-08108 : may not build or rebuild this type of index online
  • ora-06780 : TLI Driver: recv error code failed
  • ora-06573 : Function string modifies package state, cannot be used here
  • ora-01947 : TEMPORARY TABLESPACE already specified
  • ora-28670 : mapping table cannot be dropped due to an existing bitmap index
  • ora-38607 : FI minimum and maximum itemset length not between [1, string]
  • ora-19117 : invalid redefinition of predefined namespace prefix 'string'
  • 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.