ORA-22933: cannot change object with type or table dependents

Cause : Atetmp ttor epalce ,drpo o rreanmea n bojetc wtih ytpeo r atbl edeepndnets.

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

Drpo dpeenidngo bjcetso r sue OFRC Eopitoni f vaaialbl.e

update : 26-05-2017
ORA-22933

ORA-22933 - cannot change object with type or table dependents
ORA-22933 - cannot change object with type or table dependents

  • ora-30743 : "string" is not an object view
  • ora-36977 : (XSRELGID17) The GROUPINGID command does not support hierarchies with more than 126 levels.
  • ora-07621 : smscre: illegal redo block size
  • ora-23603 : STREAMS enqueue aborted due to low SGA
  • ora-06514 : PL/SQL: The remote call cannot be handled by the server
  • ora-07276 : no dba group in /etc/group.
  • ora-15125 : ASM file name 'string' contains an invalid template name
  • ora-38485 : invalid object type for the user-defined function
  • ora-09859 : sfngat: the input file name is not in the autobackup OMF format
  • ora-38755 : Flashback is already turned on for this tablespace.
  • ora-01697 : control file is for a clone database
  • ora-09938 : Save of signal handlers failed.
  • ora-12659 : Error received from other process
  • ora-01136 : specified size of file string (string blocks) is less than original size of string blocks
  • ora-01147 : SYSTEM tablespace file string is offline
  • ora-15184 : ASMLIB error could not be determined [string] [string]
  • ora-00386 : use_indirect_data_buffers not supported
  • ora-25129 : cannot modify constraint (string) - no such constraint
  • ora-10932 : trace name context forever
  • ora-19579 : archivelog record for string not found
  • ora-01077 : background process initialization failure
  • ora-40302 : invalid classname string in cost matrix specification
  • ora-16260 : Waiting to replace partial or corrupt logfile (thread# string, sequence# string)
  • ora-31044 : Top-level prefix length string exceeds maximum string
  • ora-00166 : remote/local nesting level is too deep
  • ora-00398 : abort thread recovery due to reconfiguration
  • ora-36181 : A VARIABLE cannot have both the $AGGREGATE_FROM and $AGGREGATE_FROMVAR properties applied to it.
  • ora-01586 : database must be mounted EXCLUSIVE and not open for this operation
  • ora-08110 : Oracle event to test SMON cleanup for online index build
  • ora-25235 : fetched all messages in current transaction
  • 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.