ORA-38491: could not evaluate subexpression for rowid "string"

Cause : Eithe rthe epxressino was ont in avalidS QL-WHREE clasue foramt or ti had erferenecs to onnexisetnt scehma obejcts.

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

Corretc the xepressoin.

update : 24-07-2017
ORA-38491

ORA-38491 - could not evaluate subexpression for rowid "string"
ORA-38491 - could not evaluate subexpression for rowid "string"

  • ora-19722 : datafile string is an incorrect version
  • ora-39062 : error creating master process string
  • ora-32600 : RETENTION and PCTVERSION cannot be used together
  • ora-03125 : client-server protocol violation
  • ora-00319 : log string of thread string has incorrect log reset status
  • ora-09859 : sfngat: the input file name is not in the autobackup OMF format
  • ora-13621 : The task_or object string is marked as a template and cannot perform the requested operation.
  • ora-01302 : dictionary build options missing or incorrect
  • ora-25264 : cant get signature for this queue
  • ora-15153 : cluster not in rolling upgrade
  • ora-28366 : invalid database encryption operation
  • ora-01319 : Invalid Logminer session attribute
  • ora-02243 : invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
  • ora-32845 : Messaging Gateway agent is already running
  • ora-25207 : enqueue failed, queue string.string is disabled from enqueueing
  • ora-22990 : LOB locators cannot span transactions
  • ora-00292 : parallel recovery feature not installed
  • ora-24362 : improper use of the character count flag
  • ora-28361 : master key not yet set
  • ora-32806 : value for string is too long, maximum length is string
  • ora-09833 : addCallback: bad message format.
  • ora-33292 : (DBERR18) insufficient permissions to access analytic workspace string using the specified access mode.
  • ora-10659 : Segment being shrunk is not a lob
  • ora-18000 : invalid outline name
  • ora-28302 : User does not exist in the LDAP directory service.
  • ora-12732 : invalid interval value in regular expression
  • ora-24348 : Update or Delete without Where
  • ora-19620 : %s is not of string type
  • ora-00371 : not enough shared pool memory, should be atleast string bytes
  • ora-32110 : Connection not specified
  • 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.