Re: Creating List-Partitioned Tables

Matteo D'Amato wrote:

> Hi,
> I'm trying to created a table with list partitioning. The idea is to
> have a 9 week rotation, hence w1..w9. So I thought I would convert
> billingdate to week of year. Oracle 10g complains about "PARTITION BY
> LIST ( to_char(billingdate,'WW') )". Do I need to use range instead? Can
> I do partition where values equal a week of year number? Thanks

Use RANGE.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---