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

NZE-28870: Name comparison failure

1 Answers  


ORA-16772: Error in switching over between primary and standby databases

1 Answers  


ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION

1 Answers  


ORA-38433: index "string" could not be maintained due to "string"

1 Answers  


ORA-00126: connection refused; invalid duplicity

1 Answers  






NZE-29046: Session is resumable.

1 Answers  


NID-00406: Reversion of database name failed.

1 Answers  


TNS-12601: TNS:information flags check failed

1 Answers  


SQL*Loader-03120: Resumable parameters ignored -- current session not resumable

1 Answers  


CLSR-01003: Error number encountered during mounting database

1 Answers  


ORA-13351: two or more rings of a complex polygon overlap

1 Answers  


ORA-23620: bind value size too large for PL/SQL CALL operation

1 Answers  


Categories