Database DataWarehousing (MOSC)

MOSC Banner

Partition Elimination

edited Jan 14, 2010 12:42AM in Database DataWarehousing (MOSC) 6 comments
 Hi All, Could you please clarify my doubt in partition elimination.? I have two tables TRA and TRA_DATE. TRA is partiotion by date column and further sub partitioned by string column. TRA_DATE has date column as well as the string cloumn.

ALTER SYSTEM FLUSH SHARED_POOL;

DROP TABLE TRA;

DROP TABLE TRA_DATE;

CREATE TABLE TRA(VDATE DATE, SIT VARCHAR2(10),DATA VARCHAR2(100))
PARTITION BY RANGE (VDATE)
SUBPARTITION BY HASH(SIT)
(
 PARTITION TRA2007 VALUES LESS THAN( TO_DATE('01-JAN-2008 00:00:00','dd-MON-YYYY HH24:MI:SS') )
 SUBPARTITIONS 1,
 PARTITION TRA2008 VALUES LESS THAN( TO_DATE('01-JAN-2009 00:00:00','dd-MON-YYYY HH24:MI:SS') )

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