Search the newsgroup for sequences or the documentation of sequences.
Jim
"trub3101" <michael_at_bassline01.fsnet.co.uk> wrote in message
news:a64rj4$re3$2_at_newsg2.svr.pol.co.uk...
> Hi everyone,
>
> I have just migrated a MS Access database to Oracle 8i by exporting it to
a
> flat comma-seperated file and using SQL*Loader populate the Oracle
database.
>
> After much tinkering during populating the Oracle database I now seem to
> have lost the functionality of the primary key (ref) which in Access
> automatically generated the next number for the next record appended to
the
> database.
>
> Could anyone just clarify for me whether or not Oracle provides this
> functionality?
> I suspect that it does not, not sure why?
>
> Will I have to write some sort of procedure or routine that does this?
>
> My first inkling is to create a Java singleton class that generates
> consecutive numbers when access and link it to the primary key of the
table.
> Am I mad?
>
> Thanks (in advance)
>
> tb3101
>
>
>
>
Received on Wed Mar 06 2002 - 06:15:00 CST
