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-09-2017
ORA-22933

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

  • ora-06526 : Unable to load PL/SQL library
  • ora-39085 : cannot update job string for user string
  • ora-01143 : cannot disable media recovery - file string needs media recovery
  • ora-02223 : invalid OPTIMAL storage option value
  • ora-06306 : IPA: Message write length error
  • ora-02338 : missing or invalid column constraint specification
  • ora-06521 : PL/SQL: Error mapping function
  • ora-09204 : sfotf: error opening temporary file
  • ora-06445 : ssvpstevrg: Incorrect parameters passed to function call
  • ora-34342 : (MXDSS01) IMPORTANT: Analytic workspace string is read-only. Therefore, you will not be able to use the UPDATE command to save changes to it.
  • ora-09714 : Two Task interface: cannot obtain puname
  • ora-29335 : tablespace 'string' is not read only
  • ora-12638 : Credential retrieval failed
  • ora-23346 : primary key or object ID is undefined for table or materialized view string
  • ora-16768 : SQL Apply unexpectedly offline
  • ora-36668 : (XSDPART06) string is not a legal RANGE partition.
  • ora-37031 : (XSMLTMAINT02) You cannot DELETE values of dimension workspace object in MULTI mode.
  • ora-09961 : Unable to restore termination signal handler
  • ora-12809 : cannot set string_INSTANCES when mounted in exclusive mode
  • ora-02027 : multi-row UPDATE of LONG column is not supported
  • ora-24774 : cannot switch to specified transaction
  • ora-14623 : Value string does not exist in subpartition string
  • ora-24439 : success with PLSQL compilation warning
  • ora-13773 : insufficient privileges to select data from the cursor cache
  • ora-12734 : Instant Client Light: unsupported client national character set string
  • ora-07230 : slemcr: fopen error, unable to open error file.
  • ora-06265 : NETNTT: break protocol error
  • ora-13285 : Geometry coordinate transformation error
  • ora-19860 : piece validation cannot be performed more than once
  • ora-12215 : TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA
  • 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.