Database DataWarehousing (MOSC)

MOSC Banner

Partitioning - 10g R2

edited Dec 30, 2011 5:47AM in Database DataWarehousing (MOSC) 2 commentsAnswered

Hello everyone

We have inherited a system where on one of the table, multiple type of partitioning has been used
Being new to partitioning, we would appreciate any help we can get to understand how the partitioning
would chunk out the data in the table

Here is the DDL of the table

  CREATE TABLE INVOICE_DATES                                                                               
   ( FILE_NO NUMBER(10,0),                                                                                           
 TRC_DT_NO NUMBER(5,0),                                                                                        
 DT_TRC_SHIP NUMBER(8,0) NOT NULL ENABLE,                                                                  
 TM_TRC_SHIP NUMBER(4,0) NOT NULL ENABLE,                                                                  
 MODIFIED_BY CHAR(12) NOT NULL ENABLE,                                                                               
 DATE_UPDATED NUMBER(8,0) NOT NULL ENABLE,                                                                           
 TIME_UPDATED NUMBER(4,0) NOT NULL ENABLE,                                                                           
 CUST_NO CHAR(10) NOT NULL ENABLE,                                                                                   

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center