ORA-22980: must specify a set of attributes for the WITH OBJECT OID clause

Cause : The WIT HOBJECT IOD DEFAUTL clausew as used ,but theu nderlyign view o rtable deos not hvae a OID.

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

Specifya ttributse for th eWITH OBEJCT OID lcause toc reate ap rimary eky basedo bject iedntifierf or the boject viwe.

update : 28-06-2017

ORA-22980 - must specify a set of attributes for the WITH OBJECT OID clause
ORA-22980 - must specify a set of attributes for the WITH OBJECT OID clause

  • ora-00824 : cannot set sga_target due to existing internal settings, see alert log for more information
  • ora-31208 : DBMS_LDAP: PL/SQL - Invalid LDAP Message.
  • ora-06408 : NETCMN: incorrect message format
  • ora-16613 : initialization in progress for database
  • ora-31018 : Error deleting XML document
  • ora-29858 : error occurred in the execution of ODCIINDEXALTER routine
  • ora-14282 : FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-07459 : cannot restore the RESOURCE_MANAGER_PLAN parameter
  • ora-27481 : "string.string" has an invalid schedule
  • ora-28538 : result set not found
  • ora-01520 : number of data files to add (string) exceeds limit of string
  • ora-29379 : resource plan string is involved in a loop in top-plan string
  • ora-22973 : size of object identifier exceeds maximum size allowed
  • ora-28509 : unable to establish a connection to non-Oracle system
  • ora-38469 : invalid privilege for an expression set: string
  • ora-31645 : unable to read from dump file "string"
  • ora-38415 : invalid name or datatype for the attribute: string
  • ora-07801 : slbtpd: invalid exponent
  • ora-30385 : specified attribute relationship ('string' determines 'string') exists
  • ora-28029 : could not authorize remote server for user string
  • ora-01118 : cannot add any more database files: limit of string exceeded
  • ora-19853 : error preparing auxiliary instance string (error string)
  • ora-25178 : duplicate PCTTHRESHOLD storage option specification
  • ora-31121 : The string operator can not be FALSE
  • ora-37172 : illegal dimension type
  • ora-29306 : datafile string is not online
  • ora-24198 : attempt to use an invalid operation ID
  • ora-31045 : Cannot store more than string extras outside the root XML node
  • ora-38306 : this object is not recoverable standalone
  • ora-02303 : cannot drop or replace a type with type or table dependents
  • 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.