ORA-36680: (XSDPART18) workspace object is not a dimension of the PARTITION TEMPLATE.

Cause : I nteh edfniiito no fap atriito ntmepalt,e noeo ft h eprattiinosw a sdmiesninoe db yad iemniso ntahtw a snto igvne ni hted iemniso nlsito ft h eprattiino etmlpaet.

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

Rmeoev hteo fefnidn gdmiesnino rfo mteh aprittoins' idmnesoinl its,o ra d di tt oteh aprittoint epmltaes' idmnesoinl its.

update : 20-09-2017
ORA-36680

ORA-36680 - (XSDPART18) workspace object is not a dimension of the PARTITION TEMPLATE.
ORA-36680 - (XSDPART18) workspace object is not a dimension of the PARTITION TEMPLATE.

  • ora-36698 : (XSRELTBL03) QDR dimension workspace object should be in the dimension list that dimensions the relation.
  • ora-13340 : a point geometry has more than one coordinate
  • ora-13043 : failed to read metadata from the _SDOLAYER table
  • ora-24323 : value not allowed
  • ora-13195 : failed to generate maximum tile value
  • ora-31428 : no publication contains all the specified columns
  • ora-08108 : may not build or rebuild this type of index online
  • ora-02739 : osncon: host alias is too long
  • ora-12989 : invalid value for checkpoint interval
  • ora-25302 : Operation not possible for non-buffered queue string
  • ora-09204 : sfotf: error opening temporary file
  • ora-01946 : DEFAULT TABLESPACE already specified
  • ora-37122 : AW Session cache disabled
  • ora-09919 : Unable to set label of dedicated server
  • ora-01424 : missing or illegal character following the escape character
  • ora-15203 : diskgroup string contains disks from an incompatible version of ASM
  • ora-36155 : (XSMXAGGRFROM) workspace object must be a variable or formula of a similar data type to workspace object to be used with FROM, or a TEXT variable or formula to be used with FROMVAR.
  • ora-19645 : datafile string: incremental-start SCN is prior to creation SCN string
  • ora-00097 : use of Oracle SQL feature not in SQL92 string Level
  • ora-19852 : error creating services for auxiliary instance string (error string)
  • ora-02234 : changes to this table are already logged
  • ora-29528 : invalid Java call in trigger string
  • ora-13369 : invalid value for etype in the 4-digit format
  • ora-24077 : cannot create propagation schedule for EXCEPTION queue string.string
  • ora-09882 : sstasfre/sstasdel: shmctl error, unable to remove tas shm page
  • ora-13050 : unable to construct spatial object
  • ora-29887 : cannot support row movement if domain index defined on table
  • ora-02397 : exceeded PRIVATE_SGA limit, you are being logged off
  • ora-30380 : REWRITE_TABLE does not exist
  • ora-08278 : Cannot get CPU statistics
  • 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.