Thanks for the question.

Asked: October 23, 2017 - 5:40 pm UTC

Last updated: November 20, 2017 - 1:45 am UTC

Version: 12.1.0.2

Viewed 1000+ times

You Asked

Hi,

Which of the below mentioned approaches should be better performance wise? The Update vs Insert/Delete both take almost equal time ... Is this correct or am I doing something wrong? 

I know about the limitation of Ora archive as well as the change in plan for queries which just scanned the index previously, but what surprises me is that an update takes the same time as an delete/insert.

~Regards 


-- Oracle Archive
SQL> UPDATE table1
  2     SET ora_archive_state = dbms_ilm.archivestatename (1)
  3   WHERE     column_id = 50000
  4         AND END_TIME BETWEEN TO_DATE ('01-JAN-2015 01.00.00 AM'
  5                                              , 'DD-MON-YYYY HH:MI:SS AM')
  6                                   AND TO_DATE ('01-FEB-2016 01.00.00 AM'
  7                                              , 'DD-MON-YYYY HH:MI:SS AM');

35133 rows updated.

Elapsed: 00:01:26.90

Execution Plan
----------------------------------------------------------                                          
Plan hash value: 479008084                                                                          
                                                                                                    
--------------------------------------------------------------------------------------------------------------------------------                                                                        
                                                                                                    
| Id  | Operation                                    | Name            | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |                                                                        
                                                                                                    
--------------------------------------------------------------------------------------------------------------------------------                                                                        
                                                                                                    
|   0 | UPDATE STATEMENT                             |                 | 76103 |   151M|     1   (0)| 00:00:01 |       |       |                                                                        
|   1 |  UPDATE                                      | table1          |       |       |            |          |       |       |                                                                        
|   2 |   PARTITION RANGE ITERATOR                   |                 | 76103 |   151M|     1   (0)| 00:00:01 |     2 |   398 |                                                                        
|   3 |    PARTITION HASH SINGLE                     |                 | 76103 |   151M|     1   (0)| 00:00:01 |     8 |     8 |                                                                        
|*  4 |     TABLE ACCESS BY LOCAL INDEX ROWID BATCHED| table1          | 76103 |   151M|     1   (0)| 00:00:01 |       |       |                                                                        
|*  5 |      INDEX RANGE SCAN                        | PK_table1       |     1 |       |     1   (0)| 00:00:01 |       |       |                                                                        
                                                                                                    
--------------------------------------------------------------------------------------------------------------------------------                                                                        
                                                                                                    
                                                                                                    
Predicate Information (identified by operation id):                                                 
---------------------------------------------------                                                 
                                                                                                    
   4 - filter("table1"."ORA_ARCHIVE_STATE"='0')                                               
   5 - access("column_id"=50000 AND "END_TIME">=TIMESTAMP' 2015-01-01 01:00:00' AND       
              "END_TIME"<=TIMESTAMP' 2016-02-01 01:00:00')                                 
                                                                                                    
Note                                                                                                
-----                                                                                               
   - dynamic statistics used: dynamic sampling (level=2)                                            
   - 1 Sql Plan Directive used for this statement                                                   


Statistics
----------------------------------------------------------                                          
      20897  recursive calls                                                                        
      72338  db block gets                                                                          
      98732  consistent gets                                                                        
      39275  physical reads                                                                         
   17051344  redo size                                                                              
        554  bytes sent via SQL*Net to client                                                       
        883  bytes received via SQL*Net from client                                                 
          3  SQL*Net roundtrips to/from client                                                      
        619  sorts (memory)                                                                         
          0  sorts (disk)                                                                           
      35133  rows processed                                                                         

SQL> 
SQL> COMMIT;

Commit complete.

Elapsed: 00:00:00.32

-- traditional Insert and Delete

SQL> 
SQL> INSERT INTO TABLE_ARCHIVE
  2  SELECT * FROM TABLE  WHERE COLUMN = 65001
  3         AND end_time BETWEEN TO_DATE ('01-JAN-2015 01.00.00 AM'
  4                                              , 'DD-MON-YYYY HH:MI:SS AM')
  5                                   AND TO_DATE ('01-FEB-2016 01.00.00 AM'
  6                                              , 'DD-MON-YYYY HH:MI:SS AM');

35133 rows created.

Elapsed: 00:01:18.71

Execution Plan
----------------------------------------------------------                                          
Plan hash value: 1128396010                                                                         
                                                                                                    
-------------------------------------------------------------------------------------------------------------------------------------                                                                   
                                                                                                    
| Id  | Operation                                    | Name                 | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |                                                                   
                                                                                                    
-------------------------------------------------------------------------------------------------------------------------------------                                                                   
                                                                                                    
|   0 | INSERT STATEMENT                             |                      | 60882 |   128M|     1  (0)| 00:00:01 |       |       |                                                                   
|   1 |  LOAD TABLE CONVENTIONAL                     | TABLE_ARCHIVE        |       |       |           |          |       |       |                                                                   
|   2 |   PARTITION RANGE ITERATOR                   |                      | 60882 |   128M|     1  (0)| 00:00:01 |     2 |   398 |                                                                   
|   3 |    PARTITION HASH SINGLE                     |                      | 60882 |   128M|     1   0)| 00:00:01 |     2 |     2 |                                                                   
|*  4 |     TABLE ACCESS BY LOCAL INDEX ROWID BATCHED| TABLE                | 60882 |   128M|     1  (0)| 00:00:01 |       |       |                                                                   
|*  5 |      INDEX RANGE SCAN                        | PK_TABLE             |     1 |       |     1  (0)| 00:00:01 |       |       |                                                                   
                                                                                                    
-------------------------------------------------------------------------------------------------------------------------------------                                                                   
                                                                                                    
                                                                                                    
Predicate Information (identified by operation id):                                                 
---------------------------------------------------                                                 
                                                                                                    
   5 - access("COLUMN"=65001 AND "end_time">=TIMESTAMP' 2015-01-01 01:00:00' AND       
              "end_time"<=TIMESTAMP' 2016-02-01 01:00:00')                                 
                                                                                                    
Note                                                                                                
-----                                                                                               
   - dynamic statistics used: dynamic sampling (level=2)                                            
   - 1 Sql Plan Directive used for this statement                                                   


Statistics
----------------------------------------------------------                                          
      19651  recursive calls                                                                        
       9262  db block gets                                                                          
      90084  consistent gets                                                                        
      37886  physical reads                                                                         
    8476348  redo size                                                                              
        554  bytes sent via SQL*Net to client                                                       
        862  bytes received via SQL*Net from client                                                 
          3  SQL*Net roundtrips to/from client                                                      
        542  sorts (memory)                                                                         
          0  sorts (disk)                                                                           
      35133  rows processed                                                                         

SQL> 
SQL> DELETE TABLE  WHERE COLUMN = 65001
  2         AND end_time BETWEEN TO_DATE ('01-JAN-2015 01.00.00 AM'
  3                                              , 'DD-MON-YYYY HH:MI:SS AM')
  4                                   AND TO_DATE ('01-FEB-2016 01.00.00 AM'
  5                                              , 'DD-MON-YYYY HH:MI:SS AM');

35133 rows deleted.

Elapsed: 00:00:02.91

Execution Plan
----------------------------------------------------------                                          
Plan hash value: 3384627874                                                                         
                                                                                                    
--------------------------------------------------------------------------------------------------------------------------------                                                                        
                                                                                                    
| Id  | Operation                                    | Name            | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |                                                                        
                                                                                                    
--------------------------------------------------------------------------------------------------------------------------------                                                                        
                                                                                                    
|   0 | DELETE STATEMENT                             |                 | 60882 |   121M|     1   (0)| 00:00:01 |       |       |                                                                        
|   1 |  DELETE                                      | TABLE           |       |       |            |          |       |       |                                                                        
|   2 |   PARTITION RANGE ITERATOR                   |                 | 60882 |   121M|     1   (0)| 00:00:01 |     2 |   398 |                                                                        
|   3 |    PARTITION HASH SINGLE                     |                 | 60882 |   121M|     1   (0)| 00:00:01 |     2 |     2 |                                                                        
|*  4 |     TABLE ACCESS BY LOCAL INDEX ROWID BATCHED| TABLE           | 60882 |   121M|     1   (0)| 00:00:01 |       |       |                                                                        
|*  5 |      INDEX RANGE SCAN                        | PK_TABLE        |     1 |       |     1   (0)| 00:00:01 |       |       |                                                                        
                                                                                                    
--------------------------------------------------------------------------------------------------------------------------------                                                                        
                                                                                                    
                                                                                                    
Predicate Information (identified by operation id):                                                 
---------------------------------------------------                                                 
                                                                                                    
   5 - access("COLUMN"=65001 AND "end_time">=TIMESTAMP' 2015-01-01 01:00:00' AND       
              "end_time"<=TIMESTAMP' 2016-02-01 01:00:00')                                 
                                                                                                    
Note                                                                                                
-----                                                                                               
   - dynamic statistics used: dynamic sampling (level=2)                                            
   - 1 Sql Plan Directive used for this statement                                                   


Statistics
----------------------------------------------------------                                          
         41  recursive calls                                                                        
      38257  db block gets                                                                          
      36548  consistent gets                                                                        
        135  physical reads                                                                         
   13487984  redo size                                                                              
        560  bytes sent via SQL*Net to client                                                       
        822  bytes received via SQL*Net from client                                                 
          3  SQL*Net roundtrips to/from client                                                      
          4  sorts (memory)                                                                         
          0  sorts (disk)                                                                           
      35133  rows processed                                                                         

SQL> 
SQL> COMMIT;


Please find the table details below. We have partitions for almost 2 years with almost 5 Billion rows in the same. 

CREATE TABLE TABLENAME
(
  COLUMN     NUMBER NOT NULL,
  END_TIME    TIMESTAMP(0) NOT NULL,
  COL2        NUMBER(21,6) NOT NULL,
  COL3        NUMBER(21,6),
  COL4        VARCHAR2(3 BYTE),
  COL5        VARCHAR2(3 BYTE),
  COL6        NUMBER,
  COL7        CHAR(1 BYTE),
  COL8        CHAR(1 BYTE),
  COL9        TIMESTAMP(0),
  COL10       NUMBER NOT NULL,
  COL11       NUMBER,
  COL12       NUMBER NOT NULL,
  COL13       NUMBER,
  COL14       NUMBER,
  COL15       NUMBER,
  COL16       NUMBER NOT NULL,
  COL17       NUMBER NOT NULL,
  COL18       TIMESTAMP(0) NOT NULL,
  COL19       NUMBER NOT NULL
)
NOCOMPRESS 
PARTITION BY RANGE (END_TIME)
INTERVAL( NUMTODSINTERVAL(1,'DAY'))
SUBPARTITION BY HASH (COLUMN)
SUBPARTITION TEMPLATE
  (SUBPARTITION S1 ,
   SUBPARTITION S2 ,
   SUBPARTITION S3 ,
   SUBPARTITION S4 ,
   SUBPARTITION S5 ,
   SUBPARTITION S6 ,
   SUBPARTITION S7 ,
   SUBPARTITION S8 
  )
(  
  PARTITION P_01012015 VALUES LESS THAN (TIMESTAMP' 2015-01-01 00:00:00')
);

CREATE UNIQUE INDEX P_TABLENAME ON TABLENAME
(COLUMN, END_TIME)
LOCAL (  
  PARTITION P_01012015
  ( SUBPARTITION P1_S1 ,
    SUBPARTITION P1_S2 ,
    SUBPARTITION P1_S3 ,
    SUBPARTITION P1_S4 ,
    SUBPARTITION P1_S5 ,
    SUBPARTITION P1_S6 ,
    SUBPARTITION P1_S7 ,
    SUBPARTITION P1_S8  )
NOPARALLEL
COMPRESS 1;

ALTER TABLE TABLENAME ADD (
  CONSTRAINT P_TABLENAME
  PRIMARY KEY (COLUMN, END_TIME)
  USING INDEX LOCAL
  ENABLE VALIDATE
  );

and Connor said...

Was this table *created* with row archival, or was it added later ?

I'm wondering if you're hitting a row migration issue, eg

SQL> create table tab1 (
  2    id          number,
  3    description varchar2(100),
  4    col         varchar2(1)
  5  )
  6  pctfree 0 tablespace no_assm;

Table created.

SQL>
SQL> insert into tab1
  2  select rownum,rpad('x',100),'A'
  3  from dual
  4  connect by level <= 10000;

10000 rows created.

SQL> commit;

Commit complete.

SQL>
SQL> set autotrace on stat
SQL> update tab1
  2  set col ='B';

10000 rows updated.


Statistics
----------------------------------------------------------
         17  recursive calls
      11128  db block gets
        436  consistent gets
          0  physical reads
    3799600  redo size
        867  bytes sent via SQL*Net to client
        945  bytes received via SQL*Net from client
          3  SQL*Net roundtrips to/from client
          1  sorts (memory)
          0  sorts (disk)
      10000  rows processed

So an in-place update costs me around 11128 block gets and 436 consistent gets. Now I'll add row archival:

SQL> alter table tab1 ROW ARCHIVAL;

Table altered.

SQL>
SQL> set autotrace on stat
SQL> update tab1
  2  set ora_archive_state = '1';

10000 rows updated.


Statistics
----------------------------------------------------------
         24  recursive calls
      49708  db block gets
       1282  consistent gets
          0  physical reads
    8880524  redo size
        867  bytes sent via SQL*Net to client
        960  bytes received via SQL*Net from client
          3  SQL*Net roundtrips to/from client
          4  sorts (memory)
          0  sorts (disk)
      10000  rows processed

See the huge jump in work done ? Now, that is not due to row archival, but the fact that I added the column (which consumes no space) and then updated the rows to be larger. So we had re-locate a stack of them:

SQL> analyze table tab1 compute statistics;

Table analyzed.

SQL>
SQL> select chain_cnt from user_tables
  2  where table_name = 'TAB1';

 CHAIN_CNT
----------
       413

Perhaps that is a cause for your larger than expected cost in update, as opposed to a table *created* with archival

SQL> create table tab1 (
  2    id          number,
  3    description varchar2(100),
  4    col         varchar2(2)
  5  )
  6  pctfree 0 tablespace no_assm ROW ARCHIVAL;

Table created.

SQL> insert into tab1
  2  select rownum,rpad('x',100),'A'
  3  from dual
  4  connect by level <= 10000;

10000 rows created.

SQL> commit;

Commit complete.

SQL>
SQL> set autotrace on stat
SQL> update tab1
  2  set ora_archive_state = '1';

10000 rows updated.


Statistics
----------------------------------------------------------
         15  recursive calls
        265  db block gets
        223  consistent gets
          0  physical reads
     943652  redo size
        867  bytes sent via SQL*Net to client
        960  bytes received via SQL*Net from client
          3  SQL*Net roundtrips to/from client
          1  sorts (memory)
          0  sorts (disk)
      10000  rows processed

Rating

(3 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

No chained rows

A reader, November 13, 2017 - 4:38 pm UTC

I did a check and there are no chained rows. I used the below mentioned approach

create table CHAINED_ROWS (
owner_name varchar2(30),
table_name varchar2(30),
cluster_name varchar2(30),
partition_name varchar2(30),
subpartition_name varchar2(30),
head_rowid rowid,
analyze_timestamp date
);

After a CHAINED_ROWS table is created, you specify it in the INTO clause of the ANALYZE statement.

ANALYZE TABLE row_mig_chain_demo LIST CHAINED ROWS;

SELECT owner_name,
table_name,
head_rowid
FROM chained_rows

No rows selected

November 14, 2017 - 1:19 am UTC

can we get the ddl as via dbms_metadata.get_ddl

Yes

Gh, November 14, 2017 - 9:16 am UTC

Yes pls the ddl and the changes on parameters regarding the block size since the table exists

DDL

A reader, November 17, 2017 - 2:38 pm UTC

I am able to enable ora archiving pretty quick, but to disable it takes forever? Any idea Why?
DDL from a tool, I can send from DBMS_METADATA if this does not suffice

CREATE TABLE table_name
(
COL1 NUMBER NOT NULL,
COL2 TIMESTAMP(0) NOT NULL,
COL3 NUMBER(21,6) NOT NULL,
COL4 NUMBER(21,6),
COL5 VARCHAR2(3 BYTE),
COL6 VARCHAR2(3 BYTE),
COL7 NUMBER,
COL8 CHAR(1 BYTE),
COL9 CHAR(1 BYTE),
COL10 TIMESTAMP(0),
COL11 NUMBER NOT NULL,
COL12 NUMBER,
COL13 NUMBER NOT NULL,
)
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
RESULT_CACHE (MODE DEFAULT)
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
PARTITION BY RANGE (COL2)
INTERVAL( NUMTODSINTERVAL(1,'DAY'))
SUBPARTITION BY HASH (COL1)
SUBPARTITION TEMPLATE
(SUBPARTITION TABLESPACE TABLESPACE_NAME,
SUBPARTITION TABLESPACE TABLESPACE_NAME,
SUBPARTITION TABLESPACE TABLESPACE_NAME,
SUBPARTITION TABLESPACE TABLESPACE_NAME,
SUBPARTITION TABLESPACE TABLESPACE_NAME,
SUBPARTITION TABLESPACE TABLESPACE_NAME,
SUBPARTITION TABLESPACE TABLESPACE_NAME,
SUBPARTITION TABLESPACE TABLESPACE_NAME
)
(
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-01 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
( SUBPARTITION TABLESPACE TABLESPACE_NAME,
SUBPARTITION TABLESPACE TABLESPACE_NAME,
SUBPARTITION TABLESPACE TABLESPACE_NAME,
SUBPARTITION TABLESPACE TABLESPACE_NAME,
SUBPARTITION TABLESPACE TABLESPACE_NAME,
SUBPARTITION TABLESPACE TABLESPACE_NAME,
SUBPARTITION TABLESPACE TABLESPACE_NAME,
SUBPARTITION TABLESPACE TABLESPACE_NAME ),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-02 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-03 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-04 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-05 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-06 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-07 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-08 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-09 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-10 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-11 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-12 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-13 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-14 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-15 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-16 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-17 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-18 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-19 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-20 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-21 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-22 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-23 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-24 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-25 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-26 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-27 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-28 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-29 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-30 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-01-31 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-02-01 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-02-02 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-02-03 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-02-04 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-02-05 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-02-06 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-02-07 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-02-08 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-02-09 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-02-10 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-02-11 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-02-12 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-02-13 00:00:00')
NOLOGGING
NOCOMPRESS
TABLESPACE TABLESPACE_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
SUBPARTITIONS 8 STORE IN (TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME,TABLESPACE_NAME),
PARTITION VALUES LESS THAN (TIMESTAMP' 2015-02-14 00:00:00')
NOLOGG

November 20, 2017 - 1:45 am UTC

I am able to enable ora archiving pretty quick, but to disable it takes forever? Any idea Why?

Its much easier to add a column than to drop one...

SQL> create table t as select * from dba_objects;

Table created.

SQL> set timing on
SQL> alter table t add x int;

Table altered.

Elapsed: 00:00:00.01
SQL> alter table t drop column x;

Table altered.

Elapsed: 00:00:00.44

More to Explore

Design

New to good database design? Check out Chris Saxon's full fundamentals class.

Breadcrumb

Question and Answer

You Asked

and Connor said...

Rating

Comments

No chained rows

Yes

DDL

More to Explore

Design

Performance comparison with delete and insert into backup table or using Oracle 12c archival feature

Breadcrumb

Question and Answer

You Asked

and Connor said...

Rating

Comments

No chained rows

Yes

DDL

More to Explore

Design