alter table move tablespace with blob column

From: Gringo <christianboivin1_at_hotmail.com>
Date: 18 Jan 2005 03:31:22 -0800
Message-ID: <1106047882.829182.182610@c13g2000cwb.googlegroups.com>

Hi,

I'm trying to move a table from a tablespace to another one and there's a blob column in the table, i don't know why but when i look to the objects in my tablespace, the old one contain a LOBINDEX and a LOBSEGMENT (object type)... and the new one contain the table ...

Any idea or trick will be appreciate

Thanks
Chris

i'm running std 9.2.0.1.0 on win 2000 sp4 Here's the script generate by TOAD after i'd move the table ...

CREATE TABLE REPERTOIRES_PHOTOS
(

RPH_NO_ID        NUMBER(12),
RPH_EXTENSION    VARCHAR2(3 BYTE),
RPH_IMAGE        BLOB,
RPH_DT_CREATION  DATE                         DEFAULT SYSDATE,
RPH_DT_MODIF     DATE

)

TABLESPACE JLR_PHOTO
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (

INITIAL          64K
NEXT             1M
MINEXTENTS       1
MAXEXTENTS       2147483645
PCTINCREASE      0
FREELISTS        1
FREELIST GROUPS  1
BUFFER_POOL      DEFAULT

)

LOGGING
LOB (RPH_IMAGE) STORE AS
( TABLESPACE IMAGE_DATA

ENABLE      STORAGE IN ROW
CHUNK       8192

PCTVERSION 10
NOCACHE
STORAGE (

INITIAL          64K
MINEXTENTS       1
MAXEXTENTS       2147483645
PCTINCREASE      0
FREELISTS        1
FREELIST GROUPS  1
BUFFER_POOL      DEFAULT


)

      )

NOCACHE
NOPARALLEL; Received on Tue Jan 18 2005 - 05:31:22 CST