Interesting question for Oracle Gurus (partitioned tables)

Hi:

I'm reading all i find about partitioned tables and i can't find out the solution.

The problem is:

I have to create a partitioned table by a date field, but i want to make one partition for each day i the month (only 31 partitions forever). Well, i can't find the way to extract the day of a date field in the creation script for the table.

I have to use only a date field to do the partition. I cannot use a new field for the day of the month.

Thank's a lot for the answer, please if were possible to my e-mail account
jmorales_at_dycsa.es

Bye.
;-) Received on Thu Sep 24 1998 - 06:28:53 CDT