Recreate incorrect?

[Stroeks]

Hello,

PL/SQL-Developer Version 7.1.4.1390, Database 9i and 10G

Wenn i create a table as follows:

CREATE TABLE test (
id NUMBER(19),
data BLOB ,
CONSTRAINT test_pk PRIMARY KEY (id)
USING INDEX TABLESPACE INDEX01
)
LOB(data) STORE AS test_blob (
TABLESPACE DATA02
ENABLE STORAGE IN ROW
CACHE READS NOLOGGING RETENTION
INDEX test_blob_index
) TABLESPACE DATA01;

then the recreate in PL/SQL-Developer delivers the following create table:

-- Drop table
drop table TEST cascade constraints;
-- Create table
create table TEST
(
ID NUMBER(19) not null,
DATA BLOB
)
tablespace DATA01
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table TEST
add constraint TEST_PK primary key (ID)
using index
tablespace INDEX01
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);

---> The column data is not in the tablespace i defined!

 

[Marco Kalter]

There is indeed no explicit support for LOB storage clauses. This is on the list of enhancement requests though.