Before Sybrand get to you I will ask the normal questions.
Platform? Version?
As for my questions... Do you do a cold backup every day? (I'm thinking
about an After Startup or Before Shutdown trigger which are only supported
on later versions.) or could you schedule a job to recreate the sequence on
a daily basis?
Nick Tentomas <Ntentoma_at_CSBFACMGT.CSBFM.DAL.CA> wrote in message
news:3ABB7204.CC5DC66F_at_CSBFACMGT.CSBFM.DAL.CA...
> Hi ,
>
> I need to create a sequence that will reset it self every day:
>
> For example when it is executed for a certain data it will start from
> 1..and then always add 1.
>
> If execute it for the day after it will start again from 1..and then
> always add 1.
>
> I have a table where part of the key is the a date and a sequence
> number. The application was created in mysql and I was created the
> sequences manually there but now I am hoping to use Oracles features to
> acomplish this.
>
> Thanks in advance,
>
> Nick
>
>
>
Received on Fri Mar 23 2001 - 13:27:52 CST
