Erasing OBJECT_TYPE from Oracle

Asked

Viewed 29 times

-2

Good afternoon.

How do I pay for an OBJECT_TYPE from my OWNER? need to delete this object_type, because it is giving SYNON error

oracle
  • 1

    Could you provide more information? Put the script that is giving error? I believe the solution is not to delete one object_type.

  • When I do a create table, it error saying that it already has in some table that name, but in fact it does not (I already did the test). Then he’s wrong and SYNONYM, which I know he has. I’m trying to run this script but I’m not getting DROP TYPE = 'SYNONYM' WHERE OWNER = 'SYSFOL'

1 answer

1

You can’t have one SYNONYM and one other TYPE by the same name. SYNONYM is a TYPE, as well as TABLE,PROCEDURE,FUNCTION, etc..

From what I understand, you’d have some options:

  1. Removes the SYNONYM. (if not using)
  2. Create table with another name. (if possible)
  3. Removes the SYNONYM and creates it with another name, and so creates the table with the name.

Edit: To remove a SYNONYM, just use the command:

DROP SYNONYN nome;

Source: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9002.htm

  • I want to remove SYNONYM to create a table?

  • I added the answer, see if it fits you.

  • 1

    I got it with this script drop public synonym e_movamap;

  • could you mark the question as answered ? When in doubt, visit the [tour]

Browser other questions tagged oracle

You are not signed in. Login or sign up in order to post.