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-29512: incorrectly formed name resolver specification

1 Answers  


ORA-07271: spwat: invalid oracle process number.

1 Answers  


ORA-16065: remote archival disabled at standby destination

1 Answers  


RMAN-20000: abnormal termination of job step

1 Answers   Nokia,


ORA-22950: cannot ORDER objects without MAP or ORDER method

1 Answers  






ORA-22321: method does not return any result

1 Answers  


ORA-01187: cannot read from file string because it failed verification tests

1 Answers  


ORA-16726: the external condition supplied to resource manager is invalid

1 Answers  


NNL-00523: Renames an existing name

1 Answers  


ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine

2 Answers   HCL,


PLS-00638: cannot overload MAP method

1 Answers  


RMAN-07509: List of Cataloged Files

1 Answers  


Categories