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 : 23-09-2017
ORA-38491

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

  • ora-06800 : TLI Driver: SQL*Net SPX client went away during reconnect
  • ora-07266 : sppst: invalid process number passed to sppst.
  • ora-01630 : max # extents (string) reached in temp segment in tablespace string
  • ora-09813 : Unable to get directory status
  • ora-07473 : snclrd: read error when trying to read sgadef.dbf file.
  • ora-02257 : maximum number of columns exceeded
  • ora-24911 : Cannot start listener thread at specified port
  • ora-37172 : illegal dimension type
  • ora-24043 : destination string uses a reserved name, names with AQ$_ prefix are not valid
  • ora-26711 : remote table does not contain a primary key constraint
  • ora-27473 : argument string does not exist
  • ora-29337 : tablespace 'string' has a non-standard block size (string)
  • ora-06513 : PL/SQL: index for PL/SQL table out of range for host language array
  • ora-04081 : trigger 'string' already exists
  • ora-06261 : NETNTT: nrange() failed
  • ora-36399 : (XSSPROPDTYPE) The data type of property string must be string.
  • ora-13349 : polygon boundary crosses itself
  • ora-29659 : SQLJ Object Type validation failed to get default connection
  • ora-13852 : Tracing for service(module/action) string is not enabled
  • ora-13272 : geometric object string in table string is invalid
  • ora-22153 : source variable-length array is not initialized
  • ora-01158 : database string already mounted
  • ora-31512 : name cannot contain double quotation marks
  • ora-27164 : tried to join detached thread
  • ora-23333 : column string is already part of a column group
  • ora-26650 : %s background process string might not be started successfully
  • ora-01903 : EVENTS keyword expected
  • ora-29256 : Cursor contains both regular and array defines which is illegal
  • ora-31501 : change source string is not an AutoLog change source
  • ora-01045 : user string lacks CREATE SESSION privilege; logon denied
  • 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.