Database DataWarehousing (MOSC)

MOSC Banner

can a table be partitioned by a timestamp column?

edited Jan 14, 2010 1:06AM in Database DataWarehousing (MOSC) 7 commentsAnswered ✓
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

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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center