Home » RDBMS Server » Server Administration » Partition By Range with To_DATE, Partition of a VARCHAR2 as a DATE
Partition By Range with To_DATE, Partition of a VARCHAR2 as a DATE [message #155774] Wed, 18 January 2006 08:53 Go to next message
ricardorq85
Messages: 3
Registered: December 2005
Junior Member
I have a field in a table of type VARCHAR2(40), but it really has DATE values and I need to partition the table by that field but as a DATE.

Is it possible?

How?

Thanks.

Report message to a moderator

Re: Partition By Range with To_DATE, Partition of a VARCHAR2 as a DATE [message #155839 is a reply to message #155774] Wed, 18 January 2006 21:00 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Ideally of course you should make it a date data type.

Actually stronger than that. You should, if at all possible, make it a date data type.

Either way, just range partition it.

Report message to a moderator

Previous Topic: Resetlogs
Next Topic: Transparent Gateway
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 25 10:40:38 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.