Database Administration (MOSC)

MOSC Banner

11.2.0.2.0: ORA-00955 when recreating a table

edited Oct 17, 2011 5:40AM in Database Administration (MOSC) 3 commentsAnswered
 Team,

Using 11.2.0.2.0, I am getting ORA-00955 when recreating a table in sqlplus.  Here what I did
- create table t_blob
- drop table t_blob;
- purge recyclebin;
- create table t_blob
I get ORA-00955: name is already used by an existing object
If I try one more time to create t_blob, it works (Table created.)

Here the exact code;
create table t_blob (c1 NUMBER(10),c2 VARCHAR2(64) NOT NULL,c_blob BLOB)
     TABLESPACE OM_DATA02_07  STORAGE  (INITIAL 199M NEXT 199M  MINEXTENTS 1 MAXEXTENTS UNLIMITED FREELISTS 20 PCTINCREASE 0 )
        lob (c_blob) store as t_blob_parameters (tablespace OM_DATA02_07 STORAGE  ( INITIAL 199M NEXT 199M MINEXTENTS 1

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