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-05-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-32309 : object mview type "string"."string" does not match the master table type
  • ora-06113 : NETTCP: Too many connections
  • ora-22297 : warning: Open LOBs exist at transaction commit time
  • ora-07278 : splon: ops$username exceeds buffer length.
  • ora-09214 : sfdone: I/O error detected
  • ora-00090 : failed to allocate memory for cluster database ORADEBUG command
  • ora-22150 : variable-length array has not been initialized
  • ora-22909 : exceeded maximum VARRAY limit
  • ora-06005 : NETASY: dialogue file read failure
  • ora-40201 : invalid input parameter string
  • ora-29953 : cannot issue DDL on a domain index partition marked as FAILED
  • ora-27193 : sbtinfo2 did not return volume label
  • ora-00293 : control file out of sync with redo log
  • ora-08260 : ora_addr: cannot open nameserver
  • ora-04098 : trigger 'string.string' is invalid and failed re-validation
  • ora-16236 : Logical Standby metadata operation in progress
  • ora-13182 : failed to read element string.string.string
  • ora-16233 : The table string.string is unsupported now
  • ora-07475 : slsget: cannot get vm statistics.
  • ora-06905 : CMX: connect error
  • ora-16562 : intended_state not used here, syntax error at "string"
  • ora-02336 : column attribute cannot be accessed
  • ora-13233 : failed to create sequence number [string] for R-tree
  • ora-25135 : cannot use the SINGLE TABLE option
  • ora-19924 : there are no row with id string
  • ora-13378 : invalid index for element to be extracted
  • ora-14255 : table is not partitioned by Range, Composite Range or List method
  • ora-19715 : invalid format string for generated name
  • ora-02701 : osnoraenv: error translating oracle image name
  • ora-38766 : cannot flashback data file string; file resized smaller
  • 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.