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-17502: ksfdcre:string Failed to create file string

1 Answers  


ORA-02767: Less than one request descriptor was allocated per server

1 Answers  


ORA-22131: hexadecimal string length is zero

1 Answers  


ORA-39029: worker string with process name "string" prematurely terminated

1 Answers  


RMAN-08550: autobackup search outside recovery area not attempted because DBID was not set

1 Answers  


ORA-31013: Invalid XPATH expression

1 Answers  


PLS-00379: CASE statements are not included in this release of PL/SQL

1 Answers  


ORA-24326: handle passed in is already initialized

1 Answers  


ORA-27056: could not delete file

1 Answers  


ORA-06403: Unable to allocate memory.

1 Answers  


DRG-50939: parser not set

1 Answers  


ORA-19597: file string blocksize string does not match set blocksize of string

1 Answers  


Categories