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 : 27-04-2017

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-04051 : user string cannot use database link string.string
  • ora-13910 : Parameter string cannot be NULL.
  • ora-29521 : referenced name string could not be found
  • ora-38750 : FLASHBACK DATABASE may not be performed using a dispatcher.
  • ora-09975 : kxfspini: Error Initializing SDI Process
  • ora-31160 : max substitution group size string exceeded by "string" (string) for head element "string" (string)
  • ora-31023 : Index size error
  • ora-19034 : Type not supported during schema generation
  • ora-01601 : illegal bucket size in clause "string" of string
  • ora-29319 : datafile string is not correct
  • ora-22275 : invalid LOB locator specified
  • ora-12053 : this is not a valid nested materialized view
  • ora-28001 : the password has expired
  • ora-02758 : Allocation of internal array failed
  • ora-00711 : new tablespace name is invalid
  • ora-23370 : table string and table string are not shape equivalent (string)
  • ora-06520 : PL/SQL: Error loading external library
  • ora-28544 : connect to agent failed, probable Net8 administration error
  • ora-24779 : detach not allowed with open remote cursor
  • ora-30510 : system triggers cannot be defined on the schema of SYS user
  • ora-36204 : (XSAGOP04N) In AGGMAP workspace object, the NAOPERATOR string must be HFIRST, HLAST or HEVEN.
  • ora-01266 : Unable to create unique file name
  • ora-12472 : policy string is being used
  • ora-23382 : materialized view repgroup "string"."string" is not registered at site string
  • ora-08310 : sllfop: Bad value for recsize
  • ora-19262 : XQ0042 - namespace constructor not inside an element constructor
  • ora-24328 : illegal attribute value
  • ora-19762 : invalid file type string
  • ora-01073 : fatal connection error: unrecognized call type
  • ora-28041 : Authentication protocol internal error
  • 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.