ORA-22910: cannot specify schema name for nested tables



ORA-22910: cannot specify schema name for nested tables..

Answer / guest

Cause: Table name was qualified with schema name in the
nested table column's (or attribute's) storage clause.

Action: Re-specify the nested table item's storage clause
without the schema name qualification. By default, the
storage table for the nested table item is created in the
same schema as the containing table.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24047: invalid agent name string, agent name should be of the form NAME

1 Answers  


NNL-00307: Server checkpointing its cache

1 Answers  


ORA-23411: materialized view "string"."string" is not in refresh group "string"."string"

1 Answers  


SQL*Loader-00350: Syntax error at line number.

1 Answers  


ORA-04082: NEW or OLD references not allowed in table level triggers

2 Answers   Satyam,






NNL-00341: Trace file name is now string

1 Answers  


ORA-25234: NEXT_TRANSACTION navigation option invalid for queue table string.string

1 Answers  


TNS-00548: value specified for client authentication parameter is not boolean

1 Answers  


ORA-22855: optional name for LOB storage segment incorrectly specified

1 Answers  


NNL-01045: Errors writing data stream: number

1 Answers  


ORA-09342: Detached process terminated by Oracle during shutdown abort

2 Answers  


ORA-13380: network not found

1 Answers  


Categories