Re: Clarification on Oracle sequences

From: Tim Shute <Tshute_at_nisoft.co.uk>
Date: Fri, 6 Nov 1998 15:40:09 +0000
Message-ID: <xI9PSXAZhxQ2IA$Y@nisoft.demon.co.uk>

In article <3642C4EE.C114AA20_at_india.hp.com>, Rajesh Bhave <rajeshb_at_india.hp.com> writes
>Hello Oracle gurus,
>
>Any takers for this question posted 2nd time :
>Oracle manual mentions that sequence MAXVALUE must be equal to or less
>than START WITH and must be
>greater than MINVALUE. (Oracle8 manual also mentions same). Should not
>the MAXVALUE be greater or
>equal to START WITH and greater that MINVALUE ? Is it wrongly mentioned
>in Oracle documentation. Please
>clarify.
>
>Thanks in advance and Regards,
>Rajesh Bhave
>Consultant in HP-India Software Operations
>

Rajesh

Common sense would suyggest that it is a misprint. You can specify NOMAXVALUE, which will give you 'unlimited' numbers (well OK, its actually about 9.99E28, which seems big enough). See sample below :-

CREATE SEQUENCE "FRED"."SEQUENCE_NAME" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

HTH
--
Tim Shute
Software Engineering Manager

NiSoft (UK) Limited
Unit 8, 31 Ballynahinch Road, Carryduff, BELFAST BT8 8EH Tel: +44 (0) 1232 814121, Fax: +44 (0) 1232 813962 email: tshute_at_nisoft.co.uk
Internet: www.nisoft.co.uk Received on Fri Nov 06 1998 - 09:40:09 CST