Good afternoon.
How do I pay for an OBJECT_TYPE from my OWNER? I need to delete this object_type, since it is giving SYNON error
Deleting Oracle OBJECT_TYPE
-2
asked by anonymous 08.06.2018 / 18:02
1 answer
1
You can not have a SYNONYM and a TYPE with the same name. SYNONYM is a TYPE , as is TABLE , PROCEDURE , FUNCTION , etc.
From what I understand, you would have a few options:
SYNONYM . (if you are not using it) SYNONYM and creates it with another name, and thus creates the table with the name. Edit: To remove a
SYNONYM , just use the command:
DROP SYNONYN nome;
Source: link
08.06.2018 / 19:36