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

NID-00124: Mismatched dbid for datafile string, expected number, found number

1 Answers  


RMAN-06047: duplicate datafile number specified for restoration from copy

1 Answers  


ORA-19725: can not acquire plug-in enqueue

1 Answers  


LPX-00655: Invalid output comment '~S'.

1 Answers  


NNL-00915: Authority required on server queries: string

1 Answers  


ORA-16235: DDL skipped because import has occurred

1 Answers  


ORA-01240: too many data files to add in one command

1 Answers  


LSX-00011: internal error: ~s

1 Answers  


ORA-15127: ASM file name 'string' cannot use templates

1 Answers  


AUD-00809: ORDSpeechIndex: unable to ALTER REBUILD internal Text index

1 Answers  


LFI-00148: %s can be called only on files opened in byte mode

1 Answers  


SQL*Loader-00918: The catalog must be loaded (as SYS) for SQL*Loader to be used

1 Answers  


Categories