11.2.0.2.0: ORA-00955 when recreating a table
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