ORA-37074: (XSMCSESS02) Variable workspace object has no default aggmap.

Cause : The aplpied vairable hsa no deafult agmgap

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

Use vairable wtih the edfault gagmap o raggmapd irectly

update : 24-06-2017
ORA-37074

ORA-37074 - (XSMCSESS02) Variable workspace object has no default aggmap.
ORA-37074 - (XSMCSESS02) Variable workspace object has no default aggmap.

  • ora-22602 : pickler TDS handle [string] is not well-formed
  • ora-38494 : column in the table alias and an attribute have matching names
  • ora-00069 : cannot acquire lock -- table locks disabled for string
  • ora-30024 : Invalid specification for CREATE UNDO TABLESPACE
  • ora-03252 : initial extent size not enough for LOB segment
  • ora-39049 : invalid parameter name string
  • ora-00318 : log string of thread string, expected file size string doesn't match string
  • ora-38419 : invalid identifier in attribute : string
  • ora-32103 : error from OCI call
  • ora-13303 : failure to retrieve a geometry object from a table
  • ora-09757 : osnipn: port allocation failure.
  • ora-28140 : Invalid column specified
  • ora-07844 : sllfop: LIB$GET_VM failure
  • ora-23467 : flavor lacks object "string"."string"
  • ora-19630 : end of volume encountered while copying backup piece
  • ora-01270 : %s operation is not allowed if STANDBY_PRESERVES_NAMES is true
  • ora-00281 : media recovery may not be performed using dispatcher
  • ora-29360 : retry operation. Too much concurrent activity
  • ora-01606 : gc_files_to_locks not identical to that of another mounted instance
  • ora-08109 : nosort is not a supported option for online index build
  • ora-04042 : procedure, function, package, or package body does not exist
  • ora-19574 : output filename must be specified
  • ora-22338 : must specify CASCADE INCLUDING DATA when altering the final property
  • ora-23622 : Operation string.string.string is in progress.
  • ora-02250 : missing or invalid constraint name
  • ora-01646 : tablespace 'string' is not read only - cannot make read write
  • ora-00252 : log string of thread string is empty, cannot archive
  • ora-09799 : File label retrieval failed.
  • ora-24372 : invalid object for describe
  • ora-31197 : Error in processing file string
  • 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.