SQL Developer

Hi,

when I try and create a new synonym using the "create database synonym" dialog box (right click "synonyms" in the db browser, choose "create synonym"), and then click OK, I am getting an error:

"Error in Synonyms SYNONYM1, "null" is not a valid synonym reference."

This has happened every time I've tried to create a synonym via this dialog, whether or not I change the default name (synonym1).

If you OK the error and switch to the DDL tab and click OK the synonym is created correctly, without having to make any other changes.

There also doesn't appear to be any way of refreshing the drop down boxes in the dialog - so if I change permissions via another session somewhere, I have to close the dialog and restart, rather than trying again.

Next, the synonym info window doesn't seem to show what the synonym is for, which would be useful; at the moment I have to switch to the sql window to see what the synonym points to.

Next, if you right click on a synonym and choose drop (and then ok it), the synonym is not removed from the list; you have to explicitely refresh to remove it; if you press the delete key with the synonym selected it is removed from the list without having to refresh.

Creating and dropping synonyms via the menus can also result in the synonym window refusing to display anything (just a blank tab, the only option being to close it). The window also fails to close when you delete the last synonym in the list, remaining till you explicitly refresh the synonym list. I once managed to get it into a state where I had to restart Raptor to view synonyms, but I've not been able to reproduce this.

regards,

William Moffatt