ORA-22978: only simple attribute name is allowed in the WITH OBJECT OID clause

Cause : Attempted to specify a Nested attribute in the WITH OBJECT OID clause.

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

Specify a top-level attribute of the object type of the object view.

update : 25-06-2017
ORA-22978

ORA-22978 - only simple attribute name is allowed in the WITH OBJECT OID clause
ORA-22978 - only simple attribute name is allowed in the WITH OBJECT OID clause

  • ora-04034 : unable to shrink pool to specified size
  • ora-08180 : no snapshot found based on specified time
  • ora-24756 : transaction does not exist
  • ora-12651 : Encryption or data integrity algorithm unacceptable
  • ora-19038 : Invalid opertions on query context
  • ora-22063 : reading negative value [string] as unsigned
  • ora-25407 : connection terminated
  • ora-02043 : must end current transaction before executing string
  • ora-39001 : invalid argument value
  • ora-23386 : replication parallel push cannot create slave processes
  • ora-39503 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-16165 : LGWR failed to hear from network server
  • ora-07591 : spdde: $GETJPIW failure
  • ora-02313 : object type contains non-queryable type string attribute
  • ora-10584 : Can not invoke parallel recovery for test recovery
  • ora-12457 : security label exceeded maximum allowable length
  • ora-12205 : TNS:could not get failed addresses
  • ora-31490 : could not attach to LogMiner session
  • ora-25236 : buffer too small for user data
  • ora-31517 : CDC change table string.string already exists
  • ora-19034 : Type not supported during schema generation
  • ora-39303 : schema sync or swap operation failed because of confilcts
  • ora-13637 : Executing or modifying task string is disallowed until the task is reset to its initial state.
  • ora-07650 : sigunc: $GETJPIW failure
  • ora-38490 : invalid name: quotes do not match
  • ora-07245 : sfccf: unable to lseek and write the last block.
  • ora-09883 : Two Task interface: oratab file does not exist
  • ora-01977 : Missing thread number
  • ora-16021 : session string destination cannot be the same as session string destination
  • ora-23411 : materialized view "string"."string" is not in refresh group "string"."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.