Re: Creating List-Partitioned Tables

From: Matteo D'Amato <mat_damato_at_hotmail.com>
Date: 18 Jan 2005 12:20:04 -0600
Message-ID: <Xns95E2875C4507Ematdamatohotmailcom@216.40.28.74>

Hi Morgan,

                            I tried it but I get

SQL> @test2.sql
PARTITION BY RANGE (TO_CHAR(billingdate,'ww'))

                           *

ERROR at line 122:
ORA-00907: missing right parenthesis

Any other ideas?

--Matteo

DA Morgan <damorgan_at_x.washington.edu> wrote in news:41e8924e$1_2_at_127.0.0.1:

> 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.
>
Received on Tue Jan 18 2005 - 12:20:04 CST