CREATE BUFFERPOOL LONGTEMPPOOL SIZE  21688  PAGESIZE  32  K EXTENDED STORAGE;


CREATE  SYSTEM TEMPORARY  TABLESPACE LONGTEMPSPACE PAGESIZE  32  K MANAGED BY SYSTEM  USING ('/tmp/longtempspace_.cont') EXTENTSIZE  32  OVERHEAD  24 . 1  PREFETCHSIZE  32  TRANSFERRATE  0 . 9  BUFFERPOOL LONGTEMPPOOL;

CREATE  LONG  TABLESPACE LONGUSERSPACE PAGESIZE  32  K  MANAGED BY DATABASE  USING (   FILE '/tmp/longuserspace_01'  50000     ) EXTENTSIZE  256  OVERHEAD  24 . 1  PREFETCHSIZE  256  TRANSFERRATE  0 . 9  BUFFERPOOL LONGTEMPPOOL;

CREATE  REGULAR  TABLESPACE REGULARUSERSPACE PAGESIZE  32  K  MANAGED BY DATABASE  USING (    FILE '/tmp/regularuserspace_01'  50000    ) EXTENTSIZE  256  OVERHEAD  24 . 1  PREFETCHSIZE  256  TRANSFERRATE  0 . 9  BUFFERPOOL LONGTEMPPOOL;

CREATE TABLE T1(
    id1 BIGINT NOT NULL DEFAULT  0 ,   
    value1 LONG VARCHAR NOT NULL DEFAULT ''
) DATA CAPTURE NONE   IN REGULARUSERSPACE INDEX IN REGULARUSERSPACE  LONG IN LONGUSERSPACE;