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-16001: database already open for read-only access by another instance

1 Answers  


ORA-15196: invalid ASM block header [string:string] [string] [string] [string] [string != string]

1 Answers  


ORA-30732: table contains no user-visible columns

1 Answers  


ORA-36908: (XSAGDNGL46) In AGGMAP workspace object, MODEL workspace object has the repeating dimension with the previous model.

1 Answers  


ORA-33074: (XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.

1 Answers  






DRG-13003: preference string cannot be used as a sub lexer

1 Answers  


ORA-07410: slpdtb: number too large for supplied buffer.

1 Answers  


QSM-02176: MV with UNION ALL in a view is too complex

1 Answers  


TNS-12164: TNS:Sqlnet.fdf file not present

1 Answers  


ORA-16131: An error occurred during a Terminal Recovery of the standby.

1 Answers  


NNL-00525: Shows or sets the server's default-forwarding status

1 Answers  


ORA-12093: invalid interim table "string"."string"

2 Answers  


Categories