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

ORA-13437: GeoRaster metadata blocking error

1 Answers  


ORA-07580: spstp: $GETJPIW failure

1 Answers  


ORA-01145: offline immediate disallowed unless media recovery enabled

1 Answers  


ORA-24274: no row exists in the string table for these parameters

1 Answers  


ORA-29555: Java source, class or resource is not allowed here

1 Answers  






ORA-02363: error reading from file: string

1 Answers  


RMAN-08116: output filename is original SPFILE location

1 Answers  


ORA-01270: %s operation is not allowed if STANDBY_PRESERVES_NAMES is true

1 Answers  


ORA-29840: indextype and implementation type are not in same schema

1 Answers  


ORA-14308: partition bound element must be one of: string, datetime or interval literal, number, or NULL

1 Answers  


TNS-12570: TNS:packet reader failure

1 Answers  


TNS-01017: set|show current_listener [<listener_name>]: sets|shows current listener

1 Answers  


Categories