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

NZE-29135: Seed generation for Random Number Generator failed.

1 Answers  


ORA-01646: tablespace 'string' is not read only - cannot make read write

1 Answers  


ORA-32021: parameter value longer than string characters

1 Answers  


TNS-01408: Instance "string", status string, has string handler(s) for this service...

1 Answers  


RMAN-08015: datafile string switched to datafile copy

1 Answers  






DRG-12007: You might not be allowed to use this method here, continue?

1 Answers  


ORA-25141: invalid EXTENT MANAGEMENT clause

1 Answers  


QSM-01073: materialized view, string, has a join not found in query

1 Answers  


ORA-24194: attempt to read data in a message as the wrong type

1 Answers  


ORA-02172: The PUBLIC keyword is not appropriate for a disable thread

1 Answers  


SQL-02112: SELECT..INTO returns too many rows

1 Answers  


LPX-00406: object of incorrect type passed to the function

1 Answers  


Categories