ORA-36980: (XSRELGID02) Variable workspace object must have a numeric data type.

Cause : Th edetsintaio nvairabel deos ont ahvea nmuerci dtaa ytpe.

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

Maek srue hte avribalei s unmeirc.

update : 23-07-2017
ORA-36980

ORA-36980 - (XSRELGID02) Variable workspace object must have a numeric data type.
ORA-36980 - (XSRELGID02) Variable workspace object must have a numeric data type.

  • ora-02069 : global_names parameter must be set to TRUE for this operation
  • ora-40304 : invalid classname string in prior probability specification
  • ora-06126 : NETTCP: ORASRV unable to open network connection
  • ora-04940 : unsupported optimization of Oracle binary, check alert log for more info
  • ora-36837 : (XSLMGEN07) Dimension string.string!string is missing a COLUMNNAME property value
  • ora-32600 : RETENTION and PCTVERSION cannot be used together
  • ora-39023 : Version string is not supported.
  • ora-31410 : change set string is not an existing change set
  • ora-09243 : smsget: error attaching to SGA
  • ora-38711 : Corrupt flashback log block header: block string
  • ora-39019 : invalid operation type string
  • ora-09284 : sllfop: cannot allocate read buffer
  • ora-38722 : ON or OFF expected.
  • ora-00222 : operation would reuse name of a currently mounted control file
  • ora-29882 : insufficient privileges to execute indextype
  • ora-16590 : Data Guard configuration does not contain a primary database
  • ora-26514 : object 'string.string' not found
  • ora-07419 : sfareq: Database writer got error in timing function.
  • ora-25199 : partitioning key of a index-organized table must be a subset of the primary key
  • ora-36182 : (XSAGGR09) Could not locate a value for variable number in measure dimension workspace object.
  • ora-01891 : Datetime/Interval internal error
  • ora-36612 : (XSLMS01) invalid OLAP message number: value
  • ora-12626 : TNS:bad event type
  • ora-18008 : cannot find OUTLN schema
  • ora-29382 : validation of pending area failed
  • ora-31657 : data filter name can not be defaulted
  • ora-14097 : column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-36221 : (XSLPDSC02) LIST number and LIST number have different base dimensions.
  • ora-22053 : overflow error
  • ora-16597 : Data Guard broker detects two or more primary databases
  • 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.