Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Table partitioning problem

Re: Table partitioning problem

From: <Kenneth>
Date: Tue, 20 Apr 2004 07:53:21 GMT
Message-ID: <4084d4fd.1501909@news.inet.tele.dk>


On 19 Apr 2004 15:15:42 -0700, gg_at_chandiramani.org (Omi) wrote:

>AnaCDent <anacedent_at_hotmail.com> wrote in message news:<oN_fc.46366$U83.19282_at_fed1read03>...
>> Mind your DATA TYPES
>> Strictly speaking "(1)" is NOT a VARCHAR2
>>
>> either
>> PARTITION BY RANGE (TO_NUMBER(to_char(timestamp, 'DD')))
>> or enclose the values with single quote marks
>> partition test_31 values ('31')
>
>Good point. I tried both your suggestions, but I am getting a sytax
>error on both of them:
>
>-----
>partition by range (to_number(to_char(timestamp, 'DD')))
> *
>ERROR at line 6:
>ORA-00907: missing right parenthesis
>----
>
>It seems like the "partition by range" option requires you to use a
>column name ONLY?
>
>Omi

True. The documentation clearly states that you must use a column or a list of columns.

Received on Tue Apr 20 2004 - 02:53:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US