That gets my vote as most wrong formula of the year.

cache isn't calculated like that, because cache values aren't calclated.

Cache is the number of sequence values to hold in ram so Oracle doesn't have
to go to disk to get the next one. You lose all these numbers when you shut
down the database. Your formula would mean losing mllions of numbers. It
would make the sequence unusable after the next reboot. Maybe you're trying
to trick people into doing this as a little joke?

The standard value is 10, and this is normally good enough.

losing sequence numbers is ok , as they're used for primary key generation,
and a primary key can have gaps of course.

----- Original Message -----
From: "Mohit Singla "
<oracledba-ezmlmshield-x39585601.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, August 04, 2004 2:20 PM
Subject: RE: Linux floppy boot image


> Hi Edwin,
>
> No it will not start as default value of "cycle" clause in the sequence
> create statement is "nocycle". So u have to make it to "cycle" explicitly
> along with "cache" which can be calculated by following formulae:
>
> (CEIL (MAXVALUE - MINVALUE)) / ABS (INCREMENT)
>
> Regards
>
> Mohit Singla, Valu America Inc.,113 Technology Drive,Pittsburgh, PA, 15275
> Tel: - 412-494-0400 Ext. 8107
>
>
> -----Original Message-----
> From: Edwin Uy
> [mailto:oracledba-ezmlmshield-x1901623.[Email address protected]
> Sent: Tuesday, August 03, 2004 7:27 PM
> To: LazyDBA Discussion
> Subject: Linux floppy boot image
>
> Hi guys,
>
> I know I'll have more luck here with this question in Oracle/DB2UDB
> forum than in the MSSQL DBA list ...
>
> Can anyone remind me if there is any GUI for creating a Redhat Linux
> floppy boot image or can only create one using rawrite or dd ...
>
> Cheers,
>
>
> EDWIN ONG UY
> \\|//
> (o o)
> ^"^"^"^"^"^oOOo"^(_)^"oOOo^"^"^"^"^"^"^"^"^"^"^
>
> "Choose a job you love, and you will never have to work a day in your
> life." --Confucius
> "How do I work? I grope." -- Albert Einstein
> "Experience is the best teacher, enrolling in the class is the biggest
> problem." -- Anonymous
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>


Oracle LazyDBA home page