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-05-2017
ORA-38491

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

  • ora-32578 : password for SYS already specified
  • ora-16069 : Archive Log standby database activation identifier mismatch
  • ora-13127 : failed to generate target partition
  • ora-28004 : invalid argument for function specified in PASSWORD_VERIFY_FUNCTION string
  • ora-31457 : maximum length of description field exceeded
  • ora-38505 : invalid default value for the attribute
  • ora-23414 : materialized view log for "string"."string" does not record rowid values
  • ora-07701 : sksatln: internal exception: output buffer too small
  • ora-25231 : cannot dequeue because CONSUMER_NAME not specified
  • ora-31668 : Timeout before worker process string finished initialization.
  • ora-22828 : input pattern or replacement parameters exceed 32K size limit
  • ora-32134 : Cannot assign LOBs
  • ora-01338 : Other process is attached to LogMiner session
  • ora-26101 : tablespace # in file header is string rather than string for file string
  • ora-29702 : error occurred in Cluster Group Service operation
  • ora-02084 : database name is missing a component
  • ora-25448 : rule string.string has errors
  • ora-13449 : GeoRaster metadata ULTCoordinate error
  • ora-28263 : Insufficient memory in global context pool
  • ora-07448 : ssarena: maximum number of shared arenas exceeded.
  • ora-01945 : DEFAULT ROLE[S] already specified
  • ora-02440 : Create as select with referential constraints not allowed
  • ora-01109 : database not open
  • ora-09766 : osnmop: buffer allocation failure.
  • ora-24851 : failed to connect to shared subsystem
  • ora-24000 : invalid value string, string should be of the form [SCHEMA.]NAME
  • ora-32621 : illegal aggregation in UNTIL iteration condition
  • ora-12322 : unable to mount database (link name string)
  • ora-00306 : limit of string instances in this database
  • ora-30975 : invalid Order Key Index option for XML Index
  • 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.