ORA-36720: (XSALLOC01) To be used with ALLOCATE, your AGGMAP workspace object must be defined with the ALLOCMAP command.

Cause : hT esureu es dht eGAMGPAc moamdnt oedifent ehA GGAM,Ps oiehtret ehA GGAM Pac nnoylb esudew ti hht eGARGGETA Eocmmna,do rht eGAMGPAh san ooctnnesta ttcaeh doti .t

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

sU eht eLAOLMCPAc moamdnt oedifent ehA GGAM.P

update : 20-09-2017
ORA-36720

ORA-36720 - (XSALLOC01) To be used with ALLOCATE, your AGGMAP workspace object must be defined with the ALLOCMAP command.
ORA-36720 - (XSALLOC01) To be used with ALLOCATE, your AGGMAP workspace object must be defined with the ALLOCMAP command.

  • ora-38405 : quotes not allowed in the attribute set name
  • ora-24100 : error in ktz testing layer
  • ora-33010 : (XSAGDNGL04) Relation workspace object is duplicated in the AGGMAP workspace object.
  • ora-16152 : standby database is in 'no-data-loss' protected mode
  • ora-10561 : block type 'string', data object# string
  • ora-16825 : Fast-Start Failover and other errors or warnings detected for the database
  • ora-37603 : (XSPGERRTEMPSYSTEM) Ran out of temporary storage while writing to a system temporary analytic workspace. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-24411 : Session pool already exists.
  • ora-30067 : Internal Event to turn on nested debugging info
  • ora-02154 : a tablespace with the name 'string' is found
  • ora-19688 : control file autobackup format(string) for string does not have %F
  • ora-00324 : log file 'string' translated name 'string' too long, string characters exceeds string limit
  • ora-39201 : Dump files are not supported for estimate only jobs.
  • ora-24033 : no recipients for message
  • ora-31697 : aborting operation at process order number string
  • ora-36975 : (XSRELTBL15) You must specify a USING clause naming a relation with same level dimension as LEVELORDER valueset workspace object.
  • ora-30435 : job_queue_processes must be non-zero in order to refresh summaries
  • ora-26525 : session connection attempt failed for string (@string)
  • ora-29250 : Invalid index specifed in call to dbms_sql.bind_array
  • ora-00207 : control files are not for the same database
  • ora-30190 : reserved for future use
  • ora-00396 : error string required fallback to single-pass recovery
  • ora-31441 : table is not a change table
  • ora-22065 : number to text translation for the given format causes overflow
  • ora-30180 : argument index is too large
  • ora-01151 : use media recovery to recover block, restore backup if needed
  • ora-25221 : enqueue failed, signature specified queue not supporting non-repudiation
  • ora-10945 : trace name context forever
  • ora-29801 : missing RETURN keyword
  • ora-30462 : unsupported operator: 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.