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

DRG-12438: document table release failed

1 Answers  


PLS-00717: method 'string' does not have matching signature among existing methods

1 Answers  


ORA-22614: error while construction the collection in the image

1 Answers  


NZE-29104: Cannot add certificate request.

1 Answers  


ORA-15040: diskgroup is incomplete

1 Answers  






PLS-00422: no PL/SQL translation for the bindtype given for this bind variable

1 Answers  


ORA-24383: Overflow segment of an IOT cannot be described

1 Answers  


RMAN-08503: piece handle=string comment=string

1 Answers  


PCB-00551: The SQLCA has already been included

1 Answers  


SQL*Loader-00528: OCI return status: error

1 Answers  


ORA-00092: LARGE_POOL_SIZE must be greater than LARGE_POOL_MIN_ALLOC

1 Answers  


ORA-19756: corrupt block number string found in change tracking file

1 Answers   Scope International,


Categories