ORA-29905: method string does not exist in type string.string

Cause : A requried metohd witht he reqiured singature odes note xist i nthe spceified ytpe.

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

Add th erequirde metho dto thet ype.

update : 24-06-2017
ORA-29905

ORA-29905 - method string does not exist in type string.string
ORA-29905 - method string does not exist in type string.string

  • ora-24355 : attempt to store a negative number in an Unsigned Display type.
  • ora-32344 : cannot create a secondary materialized view with synonym as base table
  • ora-00226 : operation disallowed while alternate control file open
  • ora-19240 : XP0020 - context item must be node in an axis expression
  • ora-13519 : Database id (string) exists in the workload repository
  • ora-12452 : label tag string already exists
  • ora-01451 : column to be modified to NULL cannot be modified to NULL
  • ora-12591 : TNS:event signal failure
  • ora-16517 : the object handle is invalid
  • ora-38709 : Recovery Area is not enabled.
  • ora-12090 : cannot online redefine table "string"."string"
  • ora-12047 : PCT FAST REFRESH cannot be used for materialized view "string"."string"
  • ora-15175 : cannot create alias for diskgroup metadata file 'string'
  • ora-32625 : illegal dimension in cell reference predicate
  • ora-39219 : directory object name is too long
  • ora-01952 : system privileges not granted to 'string'
  • ora-01640 : cannot make tablespace read only with active transactions
  • ora-06444 : ssvpstev: Failed with unexpected error number.
  • ora-01581 : attempt to use rollback segment (string) new extent (string) which is being allocated
  • ora-29252 : collection does not contain elements at index locations in call to dbms_sql.bind_array
  • ora-19811 : cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
  • ora-07638 : smsget: SGA pad area not large enough for created SGA
  • ora-02340 : invalid column specification
  • ora-26521 : rpc initialization error
  • ora-12800 : system appears too busy for parallel query execution
  • ora-28580 : recursive external procedures are not supported
  • ora-02379 : profile string already exists
  • ora-04008 : START WITH cannot be more than MAXVALUE
  • ora-00271 : there are no logs that need archiving
  • ora-01637 : rollback segment 'string' is being used by another instance (#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.