Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Tablepartitioning with date-columns...???
Hello Friends,
i would create a partionied table, and the table should fall into 7 partitions, each for a day of the week:
partition 1: monday
......
partition 7: sunday
I think, thats not possible with a date-column, because
...
PARTITION BY RANGE (to_char(date_column,'D'))
...
is not possible.
Have somebody an idea, how i can moke this partition with a date-column???
Thanks
M. Rabe
Stuttgart, Germany
Received on Tue Aug 10 1999 - 15:33:45 CDT