ORA-22327: cannot change a type to NOT INSTANTIABLE if it
has dependent tables



ORA-22327: cannot change a type to NOT INSTANTIABLE if it has dependent tables..

Answer / guest

Cause: An attempt was made to change a type with dependent
tables to NOT INSTANTIABLE.

Action: Drop all dependent tables of the target type and
resubmit the statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-00534: Failed to grant connection ownership to child

2 Answers  


ORA-13271: error allocating memory for geometry object

1 Answers  


DGM-16934: You must start instance "string" manually.

1 Answers  


ORA-24190: length of payload exceeds string

1 Answers  


PCC-02206: Host variables are not permitted within a DDL statement

1 Answers  






ORA-29704: cannot specify ACTIVE_INSTANCE_COUNT in 8.1.5 or earlier release

1 Answers  


RMAN-06607: RMAN configuration parameters are:

1 Answers  


RMAN-08002: starting full resync of recovery catalog

1 Answers  


DRG-10801: cannot create an SQE for another user

1 Answers  


ORA-32339: cannot alter materialized view with the PMOP

1 Answers  


PCC-02424: The number of values and host variables does not match

1 Answers  


ORA-36664: (XSDPART02) You must specify a partitioning method and one or more partition dimensions when defining a PARTITION TEMPLATE.

1 Answers  


Categories