Another Partitioning question

Hi,

I took a look at Oracle's online docu and am a little confused. What I want to do is a partitioning where I have one partition per day (yes we generate so much data). The whole thing will run on 8.1.6 and .7.

If I understood (8.1.5's) description correctly I can only limit by one value or am I wrong? Could someone give me an example of a create table-statement with a partition for a day? The Data is in full timestamp-format so I would need an upper and a lower bound I guess.

Konstantin

-- 
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood_at_agouros.de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not survive the forming of the cosmos." B'Elana Torres