Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Tablepartitioning with date-columns...???

Tablepartitioning with date-columns...???

From: Maik <maik_at_z.zgs.de>
Date: Tue, 10 Aug 1999 22:33:45 +0200
Message-ID: <7oq24l$hj01@msheas02.msh.de> 





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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US