Bug: Object rename doesn't work when owner prefix is enabled

[Lukasz Indeka]

Hi,

When Configure -> Preferences -> Options -> Always include owner prefix is turned on, then rename of view/table (and probably another type of objects) from the context menu throws an exception ORA-01765: specifying owner's name of the table is not allowed.

Steps to reproduce:

• Go to Configure -> Preferences -> Options and turn on Always include owner prefix
• Refresh the objects list so the schema name appear before the object names
• Select any view/table from the Object browser
• Right click and select Rename from the context menu
• Set the new name and press OK button

 

[Marco Kalter]

This seems to work fine for me. PL/SQL Developer correctly executes an "alter table USER.OLDNAME rename to NEWNAME" command.

Can you let me know your PL/SQL Developer version and your Oracle Server version?

 

[Lukasz Indeka]

PL/SQL Developer
Version 15.0.4.2064 (64 bit)

Using
Home: OraClient19Home1
DLL: D:\app\client\lindeka\product\19.0.0\client_1\bin\oci.dll
OCI: version 12.1 (19.3.0.0.0)
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0

 

[Marco Kalter]

That is basically the same versions I tested, so there must be some other factor involved. To obtain some more diagnostic information, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer 15\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 15 directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer 15).

 

[Lukasz Indeka]

I’ve been wrong in my initial post. The problem appears only when I try to rename a view, not a table. With tables, it works just fine with both configuration switch values.

 

[Marco Kalter]

For views (and sequences) this did indeed not work. We have fixed this for the next release.