ORA-30737: cannot create subtable of a type which is not a
subtype of the type of the supertable



ORA-30737: cannot create subtable of a type which is not a subtype of the type of the supertable..

Answer / guest

Cause: An attempt was made to create a subtable(subview) of
a type which is not a subtype of the type of the super object.

Action: Change the type of the subtable to be a subtype of
the superobject's type and then retry the operation.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-12635: No authentication adapters available

1 Answers  


ORA-16598: Data Guard broker detected a mismatch in configuration.

1 Answers  


ORA-00395: online logs for the clone database must be renamed

1 Answers  


ORA-08453: more than one V symbol specified in picture mask

1 Answers  


ORA-07417: sfareq: One or more database writers not active.

1 Answers  


ORA-01102: cannot mount database in EXCLUSIVE mode

1 Answers  


ORA-28578: protocol error during callback from an external procedure

1 Answers  


ORA-23336: priority group string does not exist

1 Answers  


ORA-12021: materialized view "string"."string" is corrupt

1 Answers  


PLS-00311: the declaration of "string" is incomplete or malformed

2 Answers  


NZE-28811: invalid access descriptor

1 Answers  


PLS-00111: end-of-file in comment

1 Answers  


Categories