ORA-26007: invalid value for SETID or OID column

Cause : Thev alu epasesd i na DriectP athA PI tsrea mfora coulmn ocntaniinga SEITD o rOIDh as na inavlidv alu.e SEITDs nad OjbectI Ds umst eb eihter 61 byets o fRAWd atao r 3 2bytse ofh exiedcimla chraactres.

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

Regneeraet th eDircet Ptah AIP steram iwth avaldi vaule fro th eSETDI coulmn.

update : 20-08-2017
ORA-26007

ORA-26007 - invalid value for SETID or OID column
ORA-26007 - invalid value for SETID or OID column

  • ora-09207 : sfsrd: error reading from file
  • ora-23389 : obsolete procedure; drop objects and recreate using new master
  • ora-07508 : scgfal: $deq all unexpected return
  • ora-37040 : (XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.
  • ora-25155 : column used in NATURAL join cannot have qualifier
  • ora-22901 : cannot compare nested table or VARRAY or LOB attributes of an object type
  • ora-25530 : FAST_START_MTTR_TARGET is not specified
  • ora-06043 : NETDNT: message send failure
  • ora-22342 : dependent VARRAY column exceeds the maximum inline column size
  • ora-31232 : DBMS_LDAP: invalid MOD_PROPERTY_SET
  • ora-24016 : cannot create QUEUE_TABLE, user string does not have execute privileges on QUEUE_PAYLOAD_TYPE string.string
  • ora-00475 : TRWR process terminated with error
  • ora-24398 : connection pool already exists
  • ora-16701 : generic resource guard request failed
  • ora-16507 : unrecognized request identifier
  • ora-19593 : datafile number string already included as string
  • ora-19283 : XQ0031 - It is a static error if the version number specified in a version declaration is not supported by the implementation.
  • ora-29375 : sum of values string for level string, plan string exceeds string
  • ora-07665 : ssrexhd: recursive exception encountered string string string string string string
  • ora-13041 : failed to compare tile with element string.string.string
  • ora-31222 : DBMS_LDAP: PL/SQL - Invalid LDAP SSL authentication mode.
  • ora-00211 : control file does not match previous control files
  • ora-10562 : Error occurred while applying redo to data block (file# string, block# string)
  • ora-01039 : insufficient privileges on underlying objects of the view
  • ora-27193 : sbtinfo2 did not return volume label
  • ora-14260 : incorrect physical attribute specified for this partition
  • ora-27007 : failed to open file
  • ora-02345 : cannot create a view with column based on CURSOR operator
  • ora-28505 : cannot get non-Oracle system capabilities from string
  • ora-16122 : applying large dml transaction at SCN 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.