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

ORA-31436: duplicate change source string

1 Answers  


PCB-00308: FOR clause is an Oracle extension

1 Answers  


ORA-14008: missing THAN keyword

1 Answers  


ORA-32037: unsupported use of LEVEL in membership condition

1 Answers  


LPX-00125: duplicate entity "~S" (ignored)

1 Answers  






ORA-24196: access the message in a wrong access mode

1 Answers  


ORA-39090: Cannot add devices to file oriented job.

1 Answers  


ORA-36640: (XSDUNION19) Concat dimension workspace object cannot be changed to UNIQUE because base dimension workspace object does not have a TEXT or ID datatype.

1 Answers  


AUD-00705: unsupported input format

1 Answers  


ORA-19900: RESETLOGS must be specified after recovery to new incarnation

1 Answers  


ORA-01518: CREATE DATABASE must specify more than one log file

1 Answers  


ORA-01480: trailing null missing from STR bind value

1 Answers   IBM,


Categories