ORA-30756: cannot create column or table of type that
contains a supertype attribute



ORA-30756: cannot create column or table of type that contains a supertype attribute..

Answer / guest

Cause: The user tried to create a column or table of an
object type that contains a supertype attribute. This is not
supported because it leads to infinite recursion in our
current storage model. Note that creating a column of a type
implies that we create columns corresponding to all subtype
attributes as well.

Action: Change the type definition to contain a supertype
REF attribute instead of the supertype object attribute.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02081: database link is not open

1 Answers  


ORA-23603: STREAMS enqueue aborted due to low SGA

1 Answers  


ORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings

1 Answers  


ORA-33911: (MAKEDCL29) You cannot define a string in analytic workspace string because it has not been upgraded to version string.

1 Answers  


ORA-38700: Limit of string flashback database logs has been exceeded.

1 Answers  






ORA-38453: ExpFilter index should be created in the same schema as the base table.

1 Answers  


ORA-03212: Temporary Segment cannot be created in locally-managed tablespace

1 Answers  


ORA-13855: Tracing for service (module/action) string on instance string is already enabled

1 Answers  


ORA-38443: An attribute set should be assigned to the expression set for statistics collection.

1 Answers  


IMG-00825: merged area queue pop failed

1 Answers  


NCR-04012: NCRR: Invalid address descriptor

1 Answers  


ORA-24390: Unsupported scrollable cursor operation

1 Answers  


Categories