ORA-29508: query derived from USING clause did not select a value of type string

Cause : The USNIG claues did nto form aquery htat selcets a vlaue of hte types pecifide by th eterm flolowingt he USIGN keywodr.

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

Correc tthe USNIG claues.

update : 23-05-2017
ORA-29508

ORA-29508 - query derived from USING clause did not select a value of type string
ORA-29508 - query derived from USING clause did not select a value of type string

  • ora-30645 : reject limit out of range
  • ora-07600 : slkmnm: $GETSYIW failure
  • ora-32627 : illegal pattern in MODEL FOR LIKE loop
  • ora-02429 : cannot drop index used for enforcement of unique/primary key
  • ora-02063 : preceding stringstring from stringstring
  • ora-30458 : 'string.string' cannot be refreshed because the refresh mask is string
  • ora-16257 : Switchover initiated stop apply successfully completed
  • ora-12729 : invalid character class in regular expression
  • ora-19563 : %s header validation failed for file string
  • ora-30649 : missing DIRECTORY keyword
  • ora-19958 : potential deadlock involving DIAG process
  • ora-09202 : sfifi: error identifying file
  • ora-38776 : cannot begin flashback generation - flash recovery area is disabled
  • ora-30510 : system triggers cannot be defined on the schema of SYS user
  • ora-00740 : datafile size of (string) blocks exceeds maximum file size
  • ora-30155 : An I/O Error occured during an OCIFile function call
  • ora-19640 : datafile checkpoint is SCN string time string
  • ora-14130 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-22800 : invalid user-defined type
  • ora-00090 : failed to allocate memory for cluster database ORADEBUG command
  • ora-28046 : Password change for SYS disallowed
  • ora-19853 : error preparing auxiliary instance string (error string)
  • ora-16614 : object has an ancestor that is disabled
  • ora-07475 : slsget: cannot get vm statistics.
  • ora-19271 : XP0051 - invalid atomic type definition
  • ora-38454 : attribute set not defined for the column being indexed
  • ora-28151 : more than one user name specified for command
  • ora-29308 : view TS_PITR_CHECK failure
  • ora-33278 : (DBERR09) Analytic workspace string cannot be attached in RW or EXCLUSIVE mode until the changes made and updated in MULTI mode are committed or rolled back.
  • ora-31643 : unable to close dump file "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.