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 : 27-04-2017
ORA-38491

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

  • ora-13916 : Invalid value "string" specified for parameter "string"
  • ora-22908 : reference to NULL table value
  • ora-31645 : unable to read from dump file "string"
  • ora-39315 : call to DBMS_SCHEMA_COPY.SWAP is not legal
  • ora-29264 : unknown or unsupported URL scheme
  • ora-24190 : length of payload exceeds string
  • ora-23416 : table "string"."string" does not contain a primary key constraint
  • ora-02447 : cannot defer a constraint that is not deferrable
  • ora-35917 : (XSHIDE05) You cannot HIDE model workspace object because the analytic workspace in which it is defined has not been upgraded to version string.
  • ora-29934 : index specified for association is not a domain index
  • ora-16742 : the standby database "string" has exhausted its quota
  • ora-37073 : (XSMCSESS01) Applied relation workspace object must be dimensioned by dimension workspace object.
  • ora-07405 : sptrap: cannot setup alternate signal stack.
  • ora-25442 : too many column values for table alias: string
  • ora-09280 : sllfcf: error closing file
  • ora-19252 : XQ0032 - too many declarations for base URI
  • ora-07757 : slemcc: invalid handle
  • ora-31528 : could not find change set string for CDC subscription string
  • ora-36208 : (XSAGOP05N) In AGGMAP workspace object, you can only specify NAOPERATOR string with the PROPORTIONAL or EVEN operators, not string.
  • ora-16095 : Dependent destination removal for inactivation
  • ora-01704 : string literal too long
  • ora-27412 : repeat interval or calendar contains invalid identifier: string
  • ora-08315 : sllfrb: Error reading file
  • ora-01010 : invalid OCI operation
  • ora-22892 : scoped table "string" does not exist in schema "string"
  • ora-27158 : process control failure
  • ora-12808 : cannot set string_INSTANCES greater than number of instances string
  • ora-00351 : recover-to time invalid
  • ora-29959 : error in the execution of the string routine for one or more of the index partitions
  • ora-14128 : FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE PARTITION
  • 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.