Home » Developer & Programmer » Data Integration » Fact table partition problems
Fact table partition problems [message #93372] Thu, 30 September 2004 02:24 Go to next message
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 Go to previous message
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.
Previous Topic: Invalid Rowid
Next Topic: Server sizing for data warehouse database
Goto Forum:
  


Current Time: Mon Aug 03 05:11:23 CDT 2020