PL/SQL (MOSC)

MOSC Banner

Issue with table creation script with online patching standard

edited Oct 16, 2015 10:00AM in PL/SQL (MOSC) 2 commentsAnswered

I am trying to create a table in Oracle R12.2.3 with Online patching standard. Issue is with the script. I have written a single script for create table for custom schema and then execute AD_ZD_TABLE.UPGRADE('CUSTOM_SCHEMA' , 'TABLE_NAME);

Now while running from UNIX Server table and synonyms are getting created but I am getting following error

Table created.

PL/SQL procedure successfully completed.

CREATE TABLE CUSTOM_TOP.TABLE_NAME

  *

ERROR at line 1:

ORA-00955: name is already used by an existing object

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

This is impacting my upcoming migrations.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center