Oracle Live SQL - Script: Exchange Partition - Does not distribute records across partitions

Statement 1

DROP TABLE requests_PART PURGE

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 2

CREATE TABLE requests_PART ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
--TABLESPACE "REQ_DATA" 
    LOB ( "REQ" ) STORE AS BASICFILE ( 
  --      TABLESPACE "REQ_DATA" 
        ENABLE STORAGE IN ROW 
        CHUNK 8192 
        RETENTION 
        NOCACHE LOGGING 
        STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
        DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    )

Table created.

Statement 3

CREATE TABLE requests ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT )

Table created.

Statement 4

DROP TABLE requests_PART PURGE

Table dropped.

Statement 5

CREATE TABLE requests_PART ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
--TABLESPACE "REQ_DATA" 
    LOB ( "REQ" ) STORE AS BASICFILE ( 
  --      TABLESPACE "REQ_DATA" 
        ENABLE STORAGE IN ROW 
        CHUNK 8192 
        RETENTION 
        NOCACHE LOGGING 
        STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
        DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    )

Table created.

Statement 6

CREATE TABLE requests ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT )

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 7

DROP TABLE requests_PART PURGE

Table dropped.

Statement 8

CREATE TABLE requests_PART ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
--TABLESPACE "REQ_DATA" 
    LOB ( "REQ" ) STORE AS BASICFILE ( 
  --      TABLESPACE "REQ_DATA" 
        ENABLE STORAGE IN ROW 
        CHUNK 8192 
        RETENTION 
        NOCACHE LOGGING 
        STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
        DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    )

Table created.

Statement 9

DROP TABLE requests

Table dropped.

Statement 10

CREATE TABLE requests ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT )

Table created.

Statement 11

DROP TABLE requests_PART PURGE

Table dropped.

Statement 12

DROP TABLE requests PURGE

Table dropped.

Statement 13

CREATE TABLE requests ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
--TABLESPACE "REQ_DATA" 
    LOB ( "REQ" ) STORE AS BASICFILE ( 
  --      TABLESPACE "REQ_DATA" 
        ENABLE STORAGE IN ROW 
        CHUNK 8192 
        RETENTION 
        NOCACHE LOGGING 
        STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
        DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    )

Table created.

Statement 14

DROP TABLE requests_part

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 15

CREATE TABLE requests_part ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    --TABLESPACE "REQ_DATA" 
        LOB ( "REQ" ) STORE AS BASICFILE ( 
        --TABLESPACE "REQ_DATA" 
            ENABLE STORAGE IN ROW 
            CHUNK 8192 
            RETENTION 
            NOCACHE LOGGING 
            STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
            DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
        ) 
    -- MONTHLY PARTITIONED ON TIMESTAMP COLUMN 
        PARTITION BY RANGE ( 
            "REQTIME" 
        ) INTERVAL ( numtoyminterval(1, 'MONTH') ) ( PARTITION "OLD_DATA" 
            VALUES LESS THAN ( TIMESTAMP ' 2013-01-01 00:00:00' ) 
        --TABLESPACE "REQ_DATA"  
        )

Table created.

Statement 16

ALTER TABLE requests_part EXCHANGE PARTITION old_data WITH TABLE requests WITHOUT VALIDATION UPDATE GLOBAL INDEXES

Table altered.

Statement 17

SELECT 
    * 
FROM 
    user_tab_partitions 
WHERE 
    table_name = 'GCCAO_INV_STAGING_PART'

no data found

Statement 18

DROP TABLE requests PURGE

Table dropped.

Statement 19

CREATE TABLE requests ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
--TABLESPACE "REQ_DATA" 
    LOB ( "REQ" ) STORE AS BASICFILE ( 
  --      TABLESPACE "REQ_DATA" 
        ENABLE STORAGE IN ROW 
        CHUNK 8192 
        RETENTION 
        NOCACHE LOGGING 
        STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
        DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    )

Table created.

Statement 20

DROP TABLE requests_part

Table dropped.

Statement 21

CREATE TABLE requests_part ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    --TABLESPACE "REQ_DATA" 
        LOB ( "REQ" ) STORE AS BASICFILE ( 
        --TABLESPACE "REQ_DATA" 
            ENABLE STORAGE IN ROW 
            CHUNK 8192 
            RETENTION 
            NOCACHE LOGGING 
            STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
            DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
        ) 
    -- MONTHLY PARTITIONED ON TIMESTAMP COLUMN 
        PARTITION BY RANGE ( 
            "REQTIME" 
        ) INTERVAL ( numtoyminterval(1, 'MONTH') ) ( PARTITION "OLD_DATA" 
            VALUES LESS THAN ( TIMESTAMP ' 2013-01-01 00:00:00' ) 
        --TABLESPACE "REQ_DATA"  
        )

Table created.

Statement 22

ALTER TABLE requests_part EXCHANGE PARTITION old_data WITH TABLE requests WITHOUT VALIDATION UPDATE GLOBAL INDEXES

Table altered.

Statement 23

SELECT 
    * 
FROM 
    user_tab_partitions 
WHERE 
    table_name = 'REQUESTS_PART'


TABLE_NAME COMPOSITE PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CACHE GLOBAL_STATS USER_STATS IS_NESTED PARENT_TABLE_PARTITION INTERVAL SEGMENT_CREATED INDEXING READ_ONLY INMEMORY INMEMORY_PRIORITY INMEMORY_DISTRIBUTE INMEMORY_COMPRESSION INMEMORY_DUPLICATE CELLMEMORY INMEMORY_SERVICE INMEMORY_SERVICE_NAME MEMOPTIMIZE_READ MEMOPTIMIZE_WRITE
REQUESTS_PART NO OLD_DATA 0 TIMESTAMP' 2013-01-01 00:00:00' 31 1 LIVESQL_USERS 10  - 1 255 65536 1048576 1 2147483645 2147483645  -  -  - YES DISABLED  -  -  -  -  -  -  -  -  - DEFAULT DEFAULT DEFAULT NO NO NO  - NO YES ON NO DISABLED  -  -  -  -  -  -  - DISABLED DISABLED

Statement 24

DROP TABLE requests PURGE

Table dropped.

Statement 25

CREATE TABLE requests ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
--TABLESPACE "REQ_DATA" 
    LOB ( "REQ" ) STORE AS BASICFILE ( 
  --      TABLESPACE "REQ_DATA" 
        ENABLE STORAGE IN ROW 
        CHUNK 8192 
        RETENTION 
        NOCACHE LOGGING 
        STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
        DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    )

Table created.

Statement 26

DROP TABLE requests_part

Table dropped.

Statement 27

CREATE TABLE requests_part ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    --TABLESPACE "REQ_DATA" 
        LOB ( "REQ" ) STORE AS BASICFILE ( 
        --TABLESPACE "REQ_DATA" 
            ENABLE STORAGE IN ROW 
            CHUNK 8192 
            RETENTION 
            NOCACHE LOGGING 
            STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
            DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
        ) 
    -- MONTHLY PARTITIONED ON TIMESTAMP COLUMN 
        PARTITION BY RANGE ( 
            "REQTIME" 
        ) INTERVAL ( numtoyminterval(1, 'MONTH') ) ( PARTITION "OLD_DATA" 
            VALUES LESS THAN ( TIMESTAMP ' 2013-01-01 00:00:00' ) 
        --TABLESPACE "REQ_DATA"  
        )

Table created.

Statement 28

ALTER TABLE requests_part EXCHANGE PARTITION old_data WITH TABLE requests WITHOUT VALIDATION UPDATE GLOBAL INDEXES

Table altered.

Statement 29

SELECT 
    * 
FROM 
    user_tab_partitions 
WHERE 
    table_name = 'REQUESTS_PART'


TABLE_NAME COMPOSITE PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CACHE GLOBAL_STATS USER_STATS IS_NESTED PARENT_TABLE_PARTITION INTERVAL SEGMENT_CREATED INDEXING READ_ONLY INMEMORY INMEMORY_PRIORITY INMEMORY_DISTRIBUTE INMEMORY_COMPRESSION INMEMORY_DUPLICATE CELLMEMORY INMEMORY_SERVICE INMEMORY_SERVICE_NAME MEMOPTIMIZE_READ MEMOPTIMIZE_WRITE
REQUESTS_PART NO OLD_DATA 0 TIMESTAMP' 2013-01-01 00:00:00' 31 1 LIVESQL_USERS 10  - 1 255 65536 1048576 1 2147483645 2147483645  -  -  - YES DISABLED  -  -  -  -  -  -  -  -  - DEFAULT DEFAULT DEFAULT NO NO NO  - NO YES ON NO DISABLED  -  -  -  -  -  -  - DISABLED DISABLED

Statement 30

DROP TABLE requests PURGE

Table dropped.

Statement 31

CREATE TABLE requests ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
--TABLESPACE "REQ_DATA" 
    LOB ( "REQ" ) STORE AS BASICFILE ( 
  --      TABLESPACE "REQ_DATA" 
        ENABLE STORAGE IN ROW 
        CHUNK 8192 
        RETENTION 
        NOCACHE LOGGING 
        STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
        DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    )

Table created.

Statement 32

DROP TABLE requests_part

Table dropped.

Statement 33

CREATE TABLE requests_part ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    --TABLESPACE "REQ_DATA" 
        LOB ( "REQ" ) STORE AS BASICFILE ( 
        --TABLESPACE "REQ_DATA" 
            ENABLE STORAGE IN ROW 
            CHUNK 8192 
            RETENTION 
            NOCACHE LOGGING 
            STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
            DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
        ) 
    -- MONTHLY PARTITIONED ON TIMESTAMP COLUMN 
        PARTITION BY RANGE ( 
            "REQTIME" 
        ) INTERVAL ( numtoyminterval(1, 'MONTH') ) ( PARTITION "OLD_DATA" 
            VALUES LESS THAN ( TIMESTAMP ' 2013-01-01 00:00:00' ) 
        --TABLESPACE "REQ_DATA"  
        )

Table created.

Statement 34

ALTER TABLE requests_part EXCHANGE PARTITION old_data WITH TABLE requests WITHOUT VALIDATION UPDATE GLOBAL INDEXES

Table altered.

Statement 35

SELECT 
    * 
FROM 
    user_tab_partitions 
WHERE 
    table_name = 'REQUESTS_PART'


TABLE_NAME COMPOSITE PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CACHE GLOBAL_STATS USER_STATS IS_NESTED PARENT_TABLE_PARTITION INTERVAL SEGMENT_CREATED INDEXING READ_ONLY INMEMORY INMEMORY_PRIORITY INMEMORY_DISTRIBUTE INMEMORY_COMPRESSION INMEMORY_DUPLICATE CELLMEMORY INMEMORY_SERVICE INMEMORY_SERVICE_NAME MEMOPTIMIZE_READ MEMOPTIMIZE_WRITE
REQUESTS_PART NO OLD_DATA 0 TIMESTAMP' 2013-01-01 00:00:00' 31 1 LIVESQL_USERS 10  - 1 255 65536 1048576 1 2147483645 2147483645  -  -  - YES DISABLED  -  -  -  -  -  -  -  -  - DEFAULT DEFAULT DEFAULT NO NO NO  - NO YES ON NO DISABLED  -  -  -  -  -  -  - DISABLED DISABLED

Statement 36

DROP TABLE requests PURGE

Table dropped.

Statement 37

CREATE TABLE requests ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
--TABLESPACE "REQ_DATA" 
    LOB ( "REQ" ) STORE AS BASICFILE ( 
  --      TABLESPACE "REQ_DATA" 
        ENABLE STORAGE IN ROW 
        CHUNK 8192 
        RETENTION 
        NOCACHE LOGGING 
        STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
        DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    )

Table created.

Statement 38

DROP TABLE requests_part

Table dropped.

Statement 39

CREATE TABLE requests_part ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    --TABLESPACE "REQ_DATA" 
        LOB ( "REQ" ) STORE AS BASICFILE ( 
        --TABLESPACE "REQ_DATA" 
            ENABLE STORAGE IN ROW 
            CHUNK 8192 
            RETENTION 
            NOCACHE LOGGING 
            STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
            DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
        ) 
    -- MONTHLY PARTITIONED ON TIMESTAMP COLUMN 
        PARTITION BY RANGE ( 
            "REQTIME" 
        ) INTERVAL ( numtoyminterval(1, 'MONTH') ) ( PARTITION "OLD_DATA" 
            VALUES LESS THAN ( TIMESTAMP ' 2013-01-01 00:00:00' ) 
        --TABLESPACE "REQ_DATA"  
        )

Table created.

Statement 40

ALTER TABLE requests_part EXCHANGE PARTITION old_data WITH TABLE requests WITHOUT VALIDATION UPDATE GLOBAL INDEXES

Table altered.

Statement 41

SELECT 
    * 
FROM 
    user_tab_partitions 
WHERE 
    table_name = 'REQUESTS_PART'


TABLE_NAME COMPOSITE PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CACHE GLOBAL_STATS USER_STATS IS_NESTED PARENT_TABLE_PARTITION INTERVAL SEGMENT_CREATED INDEXING READ_ONLY INMEMORY INMEMORY_PRIORITY INMEMORY_DISTRIBUTE INMEMORY_COMPRESSION INMEMORY_DUPLICATE CELLMEMORY INMEMORY_SERVICE INMEMORY_SERVICE_NAME MEMOPTIMIZE_READ MEMOPTIMIZE_WRITE
REQUESTS_PART NO OLD_DATA 0 TIMESTAMP' 2013-01-01 00:00:00' 31 1 LIVESQL_USERS 10  - 1 255 65536 1048576 1 2147483645 2147483645  -  -  - YES DISABLED  -  -  -  -  -  -  -  -  - DEFAULT DEFAULT DEFAULT NO NO NO  - NO YES ON NO DISABLED  -  -  -  -  -  -  - DISABLED DISABLED

Statement 42

DROP TABLE requests PURGE

Table dropped.

Statement 43

CREATE TABLE requests ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
--TABLESPACE "REQ_DATA" 
    LOB ( "REQ" ) STORE AS BASICFILE ( 
  --      TABLESPACE "REQ_DATA" 
        ENABLE STORAGE IN ROW 
        CHUNK 8192 
        RETENTION 
        NOCACHE LOGGING 
        STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
        DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    )

Table created.

Statement 44

DROP TABLE requests_part

Table dropped.

Statement 45

CREATE TABLE requests_part ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    --TABLESPACE "REQ_DATA" 
        LOB ( "REQ" ) STORE AS BASICFILE ( 
        --TABLESPACE "REQ_DATA" 
            ENABLE STORAGE IN ROW 
            CHUNK 8192 
            RETENTION 
            NOCACHE LOGGING 
            STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
            DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
        ) 
    -- MONTHLY PARTITIONED ON TIMESTAMP COLUMN 
        PARTITION BY RANGE ( 
            "REQTIME" 
        ) INTERVAL ( numtoyminterval(1, 'MONTH') ) ( PARTITION "OLD_DATA" 
            VALUES LESS THAN ( TIMESTAMP ' 2013-01-01 00:00:00' ) 
        --TABLESPACE "REQ_DATA"  
        )

Table created.

Statement 46

ALTER TABLE requests_part EXCHANGE PARTITION old_data WITH TABLE requests WITHOUT VALIDATION UPDATE GLOBAL INDEXES

Table altered.

Statement 47

SELECT 
    * 
FROM 
    user_tab_partitions 
WHERE 
    table_name = 'REQUESTS_PART'


TABLE_NAME COMPOSITE PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CACHE GLOBAL_STATS USER_STATS IS_NESTED PARENT_TABLE_PARTITION INTERVAL SEGMENT_CREATED INDEXING READ_ONLY INMEMORY INMEMORY_PRIORITY INMEMORY_DISTRIBUTE INMEMORY_COMPRESSION INMEMORY_DUPLICATE CELLMEMORY INMEMORY_SERVICE INMEMORY_SERVICE_NAME MEMOPTIMIZE_READ MEMOPTIMIZE_WRITE
REQUESTS_PART NO OLD_DATA 0 TIMESTAMP' 2013-01-01 00:00:00' 31 1 LIVESQL_USERS 10  - 1 255 65536 1048576 1 2147483645 2147483645  -  -  - YES DISABLED  -  -  -  -  -  -  -  -  - DEFAULT DEFAULT DEFAULT NO NO NO  - NO YES ON NO DISABLED  -  -  -  -  -  -  - DISABLED DISABLED

Statement 48

DROP TABLE requests PURGE

Table dropped.

Statement 49

CREATE TABLE requests ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
--TABLESPACE "REQ_DATA" 
    LOB ( "REQ" ) STORE AS BASICFILE ( 
  --      TABLESPACE "REQ_DATA" 
        ENABLE STORAGE IN ROW 
        CHUNK 8192 
        RETENTION 
        NOCACHE LOGGING 
        STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
        DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    )

Table created.

Statement 50

DROP TABLE requests_part

Table dropped.

Statement 51

CREATE TABLE requests_part ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    --TABLESPACE "REQ_DATA" 
        LOB ( "REQ" ) STORE AS BASICFILE ( 
        --TABLESPACE "REQ_DATA" 
            ENABLE STORAGE IN ROW 
            CHUNK 8192 
            RETENTION 
            NOCACHE LOGGING 
            STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
            DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
        ) 
    -- MONTHLY PARTITIONED ON TIMESTAMP COLUMN 
        PARTITION BY RANGE ( 
            "REQTIME" 
        ) INTERVAL ( numtoyminterval(1, 'MONTH') ) ( PARTITION "OLD_DATA" 
            VALUES LESS THAN ( TIMESTAMP ' 2013-01-01 00:00:00' ) 
        --TABLESPACE "REQ_DATA"  
        )

Table created.

Statement 52

ALTER TABLE requests_part EXCHANGE PARTITION old_data WITH TABLE requests WITHOUT VALIDATION UPDATE GLOBAL INDEXES

Table altered.

Statement 53

SELECT 
    * 
FROM 
    user_tab_partitions 
WHERE 
    table_name = 'REQUESTS_PART'


TABLE_NAME COMPOSITE PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CACHE GLOBAL_STATS USER_STATS IS_NESTED PARENT_TABLE_PARTITION INTERVAL SEGMENT_CREATED INDEXING READ_ONLY INMEMORY INMEMORY_PRIORITY INMEMORY_DISTRIBUTE INMEMORY_COMPRESSION INMEMORY_DUPLICATE CELLMEMORY INMEMORY_SERVICE INMEMORY_SERVICE_NAME MEMOPTIMIZE_READ MEMOPTIMIZE_WRITE
REQUESTS_PART NO OLD_DATA 0 TIMESTAMP' 2013-01-01 00:00:00' 31 1 LIVESQL_USERS 10  - 1 255 65536 1048576 1 2147483645 2147483645  -  -  - YES DISABLED  -  -  -  -  -  -  -  -  - DEFAULT DEFAULT DEFAULT NO NO NO  - NO YES ON NO DISABLED  -  -  -  -  -  -  - DISABLED DISABLED

Statement 54

DROP TABLE requests PURGE

Table dropped.

Statement 55

CREATE TABLE requests ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
--TABLESPACE "REQ_DATA" 
    LOB ( "REQ" ) STORE AS BASICFILE ( 
  --      TABLESPACE "REQ_DATA" 
        ENABLE STORAGE IN ROW 
        CHUNK 8192 
        RETENTION 
        NOCACHE LOGGING 
        STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
        DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    )

Table created.

Statement 56

DROP TABLE requests_part

Table dropped.

Statement 57

CREATE TABLE requests_part ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    --TABLESPACE "REQ_DATA" 
        LOB ( "REQ" ) STORE AS BASICFILE ( 
        --TABLESPACE "REQ_DATA" 
            ENABLE STORAGE IN ROW 
            CHUNK 8192 
            RETENTION 
            NOCACHE LOGGING 
            STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
            DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
        ) 
    -- MONTHLY PARTITIONED ON TIMESTAMP COLUMN 
        PARTITION BY RANGE ( 
            "REQTIME" 
        ) INTERVAL ( numtoyminterval(1, 'MONTH') ) ( PARTITION "OLD_DATA" 
            VALUES LESS THAN ( TIMESTAMP ' 2013-01-01 00:00:00' ) 
        --TABLESPACE "REQ_DATA"  
        )

Table created.

Statement 58

ALTER TABLE requests_part EXCHANGE PARTITION old_data WITH TABLE requests WITHOUT VALIDATION UPDATE GLOBAL INDEXES

Table altered.

Statement 59

SELECT 
    * 
FROM 
    user_tab_partitions 
WHERE 
    table_name = 'REQUESTS_PART'


TABLE_NAME COMPOSITE PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CACHE GLOBAL_STATS USER_STATS IS_NESTED PARENT_TABLE_PARTITION INTERVAL SEGMENT_CREATED INDEXING READ_ONLY INMEMORY INMEMORY_PRIORITY INMEMORY_DISTRIBUTE INMEMORY_COMPRESSION INMEMORY_DUPLICATE CELLMEMORY INMEMORY_SERVICE INMEMORY_SERVICE_NAME MEMOPTIMIZE_READ MEMOPTIMIZE_WRITE
REQUESTS_PART NO OLD_DATA 0 TIMESTAMP' 2013-01-01 00:00:00' 31 1 LIVESQL_USERS 10  - 1 255 65536 1048576 1 2147483645 2147483645  -  -  - YES DISABLED  -  -  -  -  -  -  -  -  - DEFAULT DEFAULT DEFAULT NO NO NO  - NO YES ON NO DISABLED  -  -  -  -  -  -  - DISABLED DISABLED

Statement 60

DROP TABLE requests PURGE

Table dropped.

Statement 61

CREATE TABLE requests ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
--TABLESPACE "REQ_DATA" 
    LOB ( "REQ" ) STORE AS BASICFILE ( 
  --      TABLESPACE "REQ_DATA" 
        ENABLE STORAGE IN ROW 
        CHUNK 8192 
        RETENTION 
        NOCACHE LOGGING 
        STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
        DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    )

Table created.

Statement 62

DROP TABLE requests_part

Table dropped.

Statement 63

CREATE TABLE requests_part ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    --TABLESPACE "REQ_DATA" 
        LOB ( "REQ" ) STORE AS BASICFILE ( 
        --TABLESPACE "REQ_DATA" 
            ENABLE STORAGE IN ROW 
            CHUNK 8192 
            RETENTION 
            NOCACHE LOGGING 
            STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
            DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
        ) 
    -- MONTHLY PARTITIONED ON TIMESTAMP COLUMN 
        PARTITION BY RANGE ( 
            "REQTIME" 
        ) INTERVAL ( numtoyminterval(1, 'MONTH') ) ( PARTITION "OLD_DATA" 
            VALUES LESS THAN ( TIMESTAMP ' 2013-01-01 00:00:00' ) 
        --TABLESPACE "REQ_DATA"  
        )

Table created.

Statement 64

ALTER TABLE requests_part EXCHANGE PARTITION old_data WITH TABLE requests WITHOUT VALIDATION UPDATE GLOBAL INDEXES

Table altered.

Statement 65

SELECT 
    * 
FROM 
    user_tab_partitions 
WHERE 
    table_name = 'REQUESTS_PART'


TABLE_NAME COMPOSITE PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CACHE GLOBAL_STATS USER_STATS IS_NESTED PARENT_TABLE_PARTITION INTERVAL SEGMENT_CREATED INDEXING READ_ONLY INMEMORY INMEMORY_PRIORITY INMEMORY_DISTRIBUTE INMEMORY_COMPRESSION INMEMORY_DUPLICATE CELLMEMORY INMEMORY_SERVICE INMEMORY_SERVICE_NAME MEMOPTIMIZE_READ MEMOPTIMIZE_WRITE
REQUESTS_PART NO OLD_DATA 0 TIMESTAMP' 2013-01-01 00:00:00' 31 1 LIVESQL_USERS 10  - 1 255 65536 1048576 1 2147483645 2147483645  -  -  - YES DISABLED  -  -  -  -  -  -  -  -  - DEFAULT DEFAULT DEFAULT NO NO NO  - NO YES ON NO DISABLED  -  -  -  -  -  -  - DISABLED DISABLED

Statement 66

DROP TABLE requests PURGE

Table dropped.

Statement 67

CREATE TABLE requests ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
--TABLESPACE "REQ_DATA" 
    LOB ( "REQ" ) STORE AS BASICFILE ( 
  --      TABLESPACE "REQ_DATA" 
        ENABLE STORAGE IN ROW 
        CHUNK 8192 
        RETENTION 
        NOCACHE LOGGING 
        STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
        DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    )

Table created.

Statement 68

DROP TABLE requests_part

Table dropped.

Statement 69

CREATE TABLE requests_part ( 
    reqsource  NUMBER, 
    reqtime    TIMESTAMP(6), 
    req        CLOB 
) 
SEGMENT CREATION IMMEDIATE 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING 
    STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
    DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
    --TABLESPACE "REQ_DATA" 
        LOB ( "REQ" ) STORE AS BASICFILE ( 
        --TABLESPACE "REQ_DATA" 
            ENABLE STORAGE IN ROW 
            CHUNK 8192 
            RETENTION 
            NOCACHE LOGGING 
            STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
            DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) 
        ) 
    -- MONTHLY PARTITIONED ON TIMESTAMP COLUMN 
        PARTITION BY RANGE ( 
            "REQTIME" 
        ) INTERVAL ( numtoyminterval(1, 'MONTH') ) ( PARTITION "OLD_DATA" 
            VALUES LESS THAN ( TIMESTAMP ' 2013-01-01 00:00:00' ) 
        --TABLESPACE "REQ_DATA"  
        )

Table created.

Statement 70

ALTER TABLE requests_part EXCHANGE PARTITION old_data WITH TABLE requests WITHOUT VALIDATION UPDATE GLOBAL INDEXES

Table altered.

Statement 71

SELECT 
    TABLE_NAME,COMPOSITE,PARTITION_NAME,HIGH_VALUE,HIGH_VALUE_LENGTH,PARTITION_POSITION 
FROM 
    user_tab_partitions 
WHERE 
    table_name = 'REQUESTS_PART'


TABLE_NAME COMPOSITE PARTITION_NAME HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
REQUESTS_PART NO OLD_DATA TIMESTAMP' 2013-01-01 00:00:00' 31 1

Exchange Partition - Does not distribute records across partitions

Additional Information