PLS-00714: supertypes's AUTHID is DEFINER but supertype and
subtype are not in same schema



PLS-00714: supertypes's AUTHID is DEFINER but supertype and subtype are not in same schema..

Answer / guest

Cause: The supertype's AUTHID is DEFINER, but the supertype
and subtype are defined in different schemas. SQL statements
executed in dynamically dispatched methods can potentially
pick up different values from database tables in the two
schemas.

Action: Create the subtype in the same schema as the supertype.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LPX-00272: FTP server unavailable: ~s

1 Answers  


ORA-04099: trigger 'string' is valid but not stored in compiled form

1 Answers  


ORA-32771: cannot add file to bigfile tablespace

2 Answers  


PCC-02345: SQLCHECK=SEMANTICS must be given when embedded PL/SQL blocks are used

1 Answers  


ORA-40104: invalid training data for model build

1 Answers  






ORA-24774: cannot switch to specified transaction

1 Answers  


DRG-11826: Proxy Authentication Required

1 Answers  


ORA-13183: unsupported geometric type for geometry string.string

1 Answers  


ORA-32612: invalid use of FOR loop

1 Answers  


ORA-19903: test recovery not allowed when recovering to new incarnation

1 Answers  


NNO-00083: domain "string" server "string" has no addresses

1 Answers  


ORA-12168: TNS:Unable to contact LDAP Directory Server

1 Answers  


Categories