ORA-30736: objects in a table or view hierarchy have to be
in the same schema



ORA-30736: objects in a table or view hierarchy have to be in the same schema..

Answer / guest

Cause: An attempt was made to create a subtable(subview)
under a supertable(superview) located in another schema.

Action: Connect as schema owner of the superobject and retry
the operation.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-50947: ABOUT clause not allowed without a theme index

1 Answers  


ORA-00825: cannot set db_block_buffers if sga_target set

1 Answers  


NZE-28808: Cannot retrieve method information from the configuration file.

1 Answers  


LFI-00139: Option string cannot be used with option string in calling string.

1 Answers  


ORA-39092: unable to set SCN metadata for object "string.string" of type string

1 Answers  






LRM-00114: error when processing from command line

1 Answers  


PCC-00060: Both CURSOR and STATEMENT have AT clauses at line number of file string.

1 Answers  


KUP-04075: no read access to directory object string

1 Answers  


ORA-12535: TNS:operation timed out

1 Answers  


PLS-00428: an INTO clause is expected in this SELECT statement

1 Answers  


ORA-25217: enqueue failed, visibility must be IMMEDIATE for queue string.string

1 Answers  


ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke

1 Answers  


Categories