ORA-01765: specifying owner's name of the table is not allowed

  • KM03096164
  • 15-Feb-2018
  • 15-Feb-2018

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

ORA-01765: specifying owner's name of the table is not allowed SQL statement 'RENAME "xxx" TO "yyy" could not be executed "Owner" field on the Manage Connections (Client app, File menu option).

Question

We are using Asset Manager 9.62 Build 16047 (Installed on Windows 2012 , Server Edition, 64 bit) and Oracle 12c . Our Oracle user is the schema owner and is having all the privileges still we are seeing few of the Errors while making some of the changes via App Designer.
Steps to reproduce:
1. Create a Table via App Designer
2. Create a Field and an index on the same Field
3. Save the schema strutcure. Log out .
4. Log in again in the Application Designer.
5. Drop the field (created on Step 2). Save the schema
Seems while running the Wizard it is trying to execute rename statement and failing there with Errors given in the attached screen shot.

Answer

As per Oracle forum web page this is cause by:

The error is putting the schema infront of "new_table_name". This is not needed since you can't change the schema owner with a rename statement and therefore the parameter is not allowed.

In order to fix it in Asset Manager:

There is an "Owner" field on the Manage Connections (Client app, File menu option).  This could be the cause of your issue as this field is not supposed to have a value.