Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!news-fra1.dfn.de!newsfeed.hanau.net!news.tiscali.de!tiscali!newsfeed1.ip.tiscali.net!draco.tiscalinet.it!news-f1.tiscali.it!not-for-mail
From: "mario" <xnazsco@tiscali.it>
Subject: Re: range partition on char column
Date: Fri, 07 Jul 2006 17:01:16 +0200
User-Agent: Pan/0.13.3 (That cat's something I can't explain)
Message-ID: <pan.2006.07.07.15.01.16.852314@tiscali.it>
Newsgroups: comp.databases.oracle.server
References: <pan.2006.07.07.08.49.12.364221@tiscali.it> <44ae4117$0$31648$e4fe514c@news.xs4all.nl>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: 8bit
Lines: 23
Organization: Tiscali SpA
NNTP-Posting-Host: 213.205.14.221
X-Trace: 1152284478 news.tiscali.it 991 213.205.14.221:46440
X-Complaints-To: abuse@tiscali.it
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:270575

Il Fri, 07 Jul 2006 13:05:25 +0200, Robbert van der Hoorn ha scritto:

> 
>> Where I'm wrong??
>>
>> any help will be appreciated
>> regards
>>
>> M.
>>
>>
> Mario,
> 
> looks like your ranges have overlap. Use something like BETWEEN.
> 
> Robbert


Hi, it is possible to use "between" in the
partition by range statement??

regards
M.