| Fact table partition problems [message #93372] |
Thu, 30 September 2004 02:24  |
Brayan
Messages: 315
Registered: June 2002
|
Senior Member |
|
|
Hi,
I'm having some problem in fact table partitioning. My fact table is designed as follows,
timeid - char
productid - char
customerid - char
geographyid - char
& Measures..
The best option to partition my table on geographyID by range partition. Since the column is character I can not use to_number while partitioning the table. If I use LESS THAN option for a character column the 900 comes after 1200. Actually the record containg geographyID 1200 should come in another partion because it is in another geography.
Please give me some suggestions to overcome this problem. The fact table is very huge and contains 1.5 million record a month.
Best Regards,
Ronald.
|
|
|
|
| Re: Fact table partition problems [message #93377 is a reply to message #93372] |
Mon, 04 October 2004 13:46  |
Maurice
Messages: 8
Registered: February 2002
|
Junior Member |
|
|
why are you using char for the IDs?
I recommand you to always use number.
So my solution would be to create a new table with IDs usgin numbers and populate it with the data of your existing table.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
