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-29043: Read is required.

1 Answers  


ORA-25457: evaluation function string returns failure

1 Answers  


ORA-01277: file 'string' already exists

1 Answers  


ORA-19854: error obtaining connect string from target

1 Answers  


ORA-22978: only simple attribute name is allowed in the WITH OBJECT OID clause

1 Answers  






IMG-00846: adjacency matrix allocation failed

1 Answers  


ORA-30452: cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)

1 Answers  


ORA-14633: Index maintainence clause not allowed for ADD list subpartition to a Composite partitioned table

1 Answers  


NNL-00262: Request forwarding is currently disabled

1 Answers  


ORA-16601: site contains required resources that are disabled

1 Answers  


ORA-23306: schema string does not exist

1 Answers  


NZE-28799: failure to allocate shared memory

1 Answers  


Categories