ORA-22338: must specify CASCADE INCLUDING DATA when altering the final property

Cause : A nattepmtw a smdaet oa letrt h efnia lporpret yo fat yep iwt hdpeednetn atbel()s iwtohu tsepcfiynigt h eCSACDAEI NLCUIDN GDTAA. potoin.

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

Rseumbi tteh tsaetmnetw iht hteC ACSAED NICULDNIGD AAT potoin.

update : 24-04-2017
ORA-22338

ORA-22338 - must specify CASCADE INCLUDING DATA when altering the final property
ORA-22338 - must specify CASCADE INCLUDING DATA when altering the final property

  • ora-27503 : IPC error attempting to cancel request
  • ora-24041 : propagation schedule exists for QUEUE string and DESTINATION string
  • ora-40253 : no target counter examples were found
  • ora-06020 : NETASY: initialisation failure
  • ora-24392 : no connection pool to associate server handle
  • ora-02092 : out of transaction table slots for distributed transaction
  • ora-19594 : control file already included as string
  • ora-06950 : No error
  • ora-07281 : slsget: times error, unable to get cpu time.
  • ora-13150 : failed to insert exception record
  • ora-19861 : additional backup pieces cannot be validated in this conversation
  • ora-08468 : mask option string is not supported
  • ora-12589 : TNS:connection not bequeathable
  • ora-06448 : ssvpstp: Failed with unexpected error number.
  • ora-40203 : model string does not exist
  • ora-34489 : (MXMAINT06) You cannot maintain workspace object because it is a SURROGATE.
  • ora-19731 : cannot apply change to unverified plugged-in datafile string
  • ora-12649 : Unknown encryption or data integrity algorithm
  • ora-14049 : invalid ALTER TABLE MODIFY PARTITION option
  • ora-02460 : Inappropriate index operation on a hash cluster
  • ora-01257 : cannot reuse database file string, unknown file size
  • ora-25110 : NOSORT may not be used with a bitmap index
  • ora-23332 : group string is in use; cannot drop
  • ora-29849 : error occurred in the execution of ODCIINDEXSPLITPARTITION routine
  • ora-16233 : The table string.string is unsupported now
  • ora-28594 : agent control utility: invalid parameter name
  • ora-36680 : (XSDPART18) workspace object is not a dimension of the PARTITION TEMPLATE.
  • ora-16708 : the state supplied to resource guard is invalid
  • ora-06263 : NETNTT: out of memory in pi_connect
  • ora-27005 : cannot open file for async I/O on device not supporting async
  • 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.