ORA-30731: scope constraint not allowed on nested table
column when the nested table is being created



ORA-30731: scope constraint not allowed on nested table column when the nested table is being creat..

Answer / guest

Cause: An attempt was made to define a scope constraint on a
nested table column when the nested table is being created.

Action: Do not specify a scope constraint on a nested table
column when creating it. Instead, specify it using the ALTER
TABLE statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNO-00264: configuration database query returned no data

1 Answers  


RMAN-06735: Do you really want to drop the database (enter YES or NO)?

1 Answers  


ORA-07715: sksadtd: could not dismount archival device (SYS$DISMNT failure)

1 Answers  


PLS-00908: The stored format of string is not supported by this release

1 Answers   TCS,


ORA-39116: invalid trigger operation on mutating table string.string

1 Answers  






ORA-32004: obsolete and/or deprecated parameter(s) specified

1 Answers  


ORA-38309: object not purgable

1 Answers  


RMAN-20204: translation not started

1 Answers  


NMP-00005: general SNMP error

1 Answers  


ORA-01545: rollback segment 'string' specified not available

1 Answers  


ORA-16070: parameter string contains an invalid REGISTER attribute value

1 Answers  


O2U-00200: Internal error in OTT facility O2U

1 Answers  


Categories