ORA-36393: (XSMXCLEA03) When using the AGGREGATES, CHANGES or CACHE options, you must specify the ALL keyword.

Cause : The use rdidn't sue the ALL keywor dwhen usnig CHANGSE or CACEH

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

Specifyt he ALL ekyword

update : 24-08-2017

ORA-36393 - (XSMXCLEA03) When using the AGGREGATES, CHANGES or CACHE options, you must specify the ALL keyword.
ORA-36393 - (XSMXCLEA03) When using the AGGREGATES, CHANGES or CACHE options, you must specify the ALL keyword.

  • ora-27020 : named devices not supported
  • ora-38608 : FI itemset minimum-length(string) should not be greater than maximum length(string)
  • ora-37177 : column string does not have any leaf values
  • ora-12476 : least upper bound resulted in an invalid OS label
  • ora-12802 : parallel query server lost contact with coordinator
  • ora-15093 : buffer only contains string bytes, I/O requested is string bytes
  • ora-25205 : the QUEUE string.string does not exist
  • ora-02232 : invalid MOUNT mode
  • ora-13042 : invalid SDO_LEVEL and SDO_NUMTILES combination
  • ora-36182 : (XSAGGR09) Could not locate a value for variable number in measure dimension workspace object.
  • ora-12545 : Connect failed because target host or object does not exist
  • ora-01198 : must specify size for log file if RESETLOGS
  • ora-30345 : circular dimension hierarchy
  • ora-24439 : success with PLSQL compilation warning
  • ora-23451 : flavor string already defined for object group "string"."string"
  • ora-00283 : recovery session canceled due to errors
  • ora-32021 : parameter value longer than string characters
  • ora-32508 : no such watchpoint id
  • ora-16543 : invalid request made to broker
  • ora-27089 : unable to release advisory lock
  • ora-24306 : bad buffer for piece
  • ora-24355 : attempt to store a negative number in an Unsigned Display type.
  • ora-39044 : Metadata transform string has already been specified.
  • ora-01634 : rollback segment number 'string' is about to go offline
  • ora-27015 : skgfcls: failed to close the file
  • ora-19677 : RMAN configuration name exceeds maximum length of string
  • ora-12990 : duplicate option specified
  • ora-35078 : (QFHEAD05) An EIF extension file header for string is not in the correct format.
  • ora-39203 : Partition selection is not supported over a network link.
  • ora-08194 : Flashback Table operation is not allowed on materialized views
  • 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.