can a table be partitioned by a timestamp column?
I am using oracle 10.2.0.3 and trying to partition a table by a timestamp column. I see the following error:
ORA-14019: partition bound element must be one of: string, datetime or interval
literal, number, or MAXVALUE
ORA-14019: partition bound element must be one of: string, datetime or interval
literal, number, or MAXVALUE
This is the first time I have tried to use a TS column a a partitioning column. I have used a date and a number before. My reading of this error is that I can't do it. Am I correct?
Thank you
0