Database Administration (MOSC)

MOSC Banner

name is already used

edited Jun 13, 2012 12:50PM in Database Administration (MOSC) 11 commentsAnswered
Team,

        I get
ORA-00955: name is already used by an existing object
When I try to recreate a table that has a blob in oracle 11.2.0.2.

Here the steps that are execute in  pl/sql code.

- drop table MY_TABLE CASCADE CONSTRAINTS PURGE;
- purge recyclebin
- create table MY_TABLE ..
Ex: ORA-00955: name is already used by an existing object

It does not happen all the time.

Any Help is really appreciated.

Hisham

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