Re: Table partitioning problem

From: Omi <gg_at_chandiramani.org>
Date: 19 Apr 2004 15:15:42 -0700
Message-ID: <e01d2feb.0404191415.7e1a55ab@posting.google.com>

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 Received on Mon Apr 19 2004 - 17:15:42 CDT