ORA-30756: cannot create column or table of type that
contains a supertype attribute
- 1 Answers
- 3208 Views
- I also Faced
- E-Mail Answers
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 |
CLSR-00506: Unmatched resource name prefix string is specified
ORA-31025: Invalid document element
NNO-00058: cannot load topology data from configuration database
ORA-23322: Privilege error accessing pipe
ORA-22974: missing WITH OBJECT OID clause
PLS-01711: A SELECT statement may not contain ORDER_BY, HAVING, or GROUP_BY clause
ORA-27040: file create error, unable to create file
RMAN-08126: keep attributes for the proxy copy are changed
SQL*Loader-00528: OCI return status: error
ORA-13352: the coordinates do not describe a circle
ORA-06109: NETTCP: message receive failure
SQL*Loader-00401: End field position number must be greater than or equal to start number
Oracle Errors 
