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

RMAN-06055: could not find log sequence string thread string

1 Answers  


ORA-00110: invalid value string for attribute string, must be between string and string

1 Answers  


ORA-12676: Server received internal error from client

1 Answers  


UDE-00001: user requested cancel of current operation

1 Answers  


NZE-29039: There are no matching cipher suites.

1 Answers  






TNS-00315: Failed to allocate larger connect data area for getting pump data: number

1 Answers  


LFI-00126: Record format can only be one of Fixed or Variable.

1 Answers  


PCB-00501: Runtime context variable "string" not of correct type

1 Answers  


ORA-27463: invalid program type string

1 Answers  


PLS-00356: 'string' must name a table to which the user has access

1 Answers  


DRG-12437: highlight table release failed

1 Answers  


RMAN-06189: current DBID number does not match target mounted database (number)

1 Answers  


Categories