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

TNS-04079: Cannot administer Oracle Connection Manager with no CMAN.ORA, and port = number.

1 Answers  


RMAN-05011: auxiliary instance must be in nomount state for TSPITR

1 Answers  


PCB-00105: Included file name "string" exceeds name limit of number characters

1 Answers  


ORA-00353: log corruption near block string change string time string

1 Answers  


RMAN-06047: duplicate datafile number specified for restoration from copy

1 Answers  






ORA-00270: error creating archive log string

1 Answers  


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

1 Answers  


ORA-06562: type of out argument must match type of column or bind variable

1 Answers  


TNS-01179: Listener cannot load instance class "string"

1 Answers  


ORA-32730: Command cannot be executed on remote instance

1 Answers  


SQL-02136: Invalid NCHAR character set id

1 Answers  


ORA-06813: TLI Driver: the configured ethernet address is incorrect

1 Answers  


Categories