-
getting partition name for a value
Is the a query I can issue that will return me the partition name based on
a specific value of the column that is being paritioned/
Assume I have the following table definition (see below). What query
can I use to find the parition name for dt=20101231
In the example below I would expect to see "part1"
CREATE TABLE t
(
dt date,
x int,
y char(2000)
)
PARTITION BY RANGE (dt)
(
PARTITION part1 VALUES LESS THAN (to_date('05-jan-2011','dd-mon-yyyy')) ,
PARTITION part2 VALUES LESS THAN (to_date('06-jan-2011','dd-mon-yyyy')) ,
PARTITION junk VALUES LESS THAN (MAXVALUE)
) storage ( initial 10m ) tablespace users
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|