ORA-33006: (XSAGDNGL02) The relation workspace object is not related to itself.

Cause : A realtionw as nmaed i na REALTIONc laus eof teh AGGAMP thta is ont a eslf-rleatio.n

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

Namea valdi sel-frelaiton i nthe ERLATINO staetment.

update : 24-05-2017

ORA-33006 - (XSAGDNGL02) The relation workspace object is not related to itself.
ORA-33006 - (XSAGDNGL02) The relation workspace object is not related to itself.

  • ora-38754 : FLASHBACK DATABASE not started; required redo log is not available
  • ora-27162 : thread creation failed
  • ora-01261 : Parameter string destination string cannot be translated
  • ora-07755 : slemcf: fseek before read failure
  • ora-00297 : must specify RECOVER DATAFILE LIST before RECOVER DATAFILE START
  • ora-13040 : failed to subdivide tile
  • ora-06565 : cannot execute string from within stored procedure
  • ora-02093 : TRANSACTIONS_PER_ROLLBACK_SEGMENT(string) more than maximum possible(string)
  • ora-28280 : Multiple entries for ORACLE database password exist.
  • ora-22998 : CLOB or NCLOB in multibyte character set not supported
  • ora-31464 : target table for the change table no longer exists
  • ora-01764 : new update value of join is not guaranteed to be unique
  • ora-01585 : error identifying backup file string
  • ora-01308 : initialization parameter utl_file_dir is not set
  • ora-29306 : datafile string is not online
  • ora-15027 : active use of diskgroup "string" precludes its dismount
  • ora-32342 : The EXPLAIN_MVIEW facility failed to explain the materialized view statement
  • ora-31028 : Resource metadata length string exceeded maximum length string
  • ora-16256 : Failure to complete standby redo logfile archival after failover
  • ora-40108 : input data contains too few distinct target (string) values
  • ora-26045 : REF column string expects string arguments; found string.
  • ora-08468 : mask option string is not supported
  • ora-23407 : object name string must be shaped like "schema"."object" or "object"
  • ora-12921 : database is not in force logging mode
  • ora-32012 : failure in processing system parameters from restored SPFILE
  • ora-13267 : error reading data from layer table string
  • ora-09805 : conversion of category number to string failed.
  • ora-32317 : cannot run a job from a job
  • ora-01969 : You must specify RESETLOGS or NORESETLOGS
  • ora-06133 : NETTCP: file not found
  • 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.