Ora-955 When Moving Lob Partitions To Another Tablespace (Doc ID 435843.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Description of partitioned table :

SQL> desc scb_images 
Name Null? Type
----------------------------------------- -------- ----------------------------
ACCNO CHAR(7 CHAR)
PAYREF VARCHAR2(16 CHAR)
MSGREF1 VARCHAR2(16 CHAR)
MSGREF2 VARCHAR2(16 CHAR)
PAYDT CHAR(9 CHAR)
DOCID NOT NULL CHAR(8 CHAR)
SCANDT CHAR(9 CHAR)
LOCATION VARCHAR2(5 CHAR)
IID VARCHAR2(32 CHAR)
FEED_DATE DATE
IMAGE ORDIMAGE

When moving lob partitions to another tablespace it works for the first one but fails on the others :


SQL> alter table SCB_IMAGES move partition P20000501_20000531 tablespace 

CERS_SEARCH_DATA_T3_TS lob (image.source.localdata) store as lobsegment
(tablespace CERS_SEARCH_DATA_T3_TS);

Table altered.




SQL> alter table SCB_IMAGES move partition P20000601_20000630 tablespace
CERS_SEARCH_DATA_T3_TS lob (image.source.localdata) store as lobsegment (tablespace CERS_SEARCH_DATA_T3_TS)

*
ERROR at line 1:
ORA-955 : name is already used by an existing object




Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms