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 : 28-06-2017

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

  • ora-02180 : invalid option for CREATE TABLESPACE
  • ora-25254 : time-out in LISTEN while waiting for a message
  • ora-16045 : circular archive log destination dependency chain
  • ora-24384 : Application context size is not initialized
  • ora-14022 : creation of LOCAL partitioned cluster indices is not supported
  • ora-22153 : source variable-length array is not initialized
  • ora-29336 : Internal error [string] [string] from DBMS_PLUGTS
  • ora-14191 : ALLOCATE STORAGE may not be specified for Composite Range partitioned object
  • ora-14049 : invalid ALTER TABLE MODIFY PARTITION option
  • ora-08437 : invalid picture type in picture mask
  • ora-28100 : policy function schema string is invalid
  • ora-27435 : chain job terminated abnormally
  • ora-22805 : cannot insert NULL object into object tables or nested tables
  • ora-07564 : sldext: wildcard in filename or extension
  • ora-09284 : sllfop: cannot allocate read buffer
  • ora-07552 : sftget: $GET failure
  • ora-12985 : tablespace 'string' is read only, cannot drop column
  • ora-01345 : must be a LogMiner coordinator process
  • ora-25018 : conflicting trigger string already exists
  • ora-12161 : TNS:internal error: partial data received
  • ora-14638 : cannot MERGE subpartitions in different Range Composite partitions
  • ora-38430 : Operation "string" not supported in the current release.
  • ora-16739 : redo transport service for standby database "string" unexpectedly online
  • ora-09751 : pw_attachPorts: server call pws_attach failed.
  • ora-30371 : column cannot define a level in more than one dimension
  • ora-01226 : file header of log member is inconsistent with other members
  • ora-13206 : internal error [string] while creating the spatial index
  • ora-22294 : cannot update a LOB opened in read-only mode
  • ora-32586 : multiple specification of a supplemental logging attribute
  • ora-01609 : log string is the current log for thread string - cannot drop members
  • 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.