AUTO_INCREMENT PK Column for Oracle Table [message #2151] |
Tue, 23 June 2009 10:10 ![Go to next message Go to previous message](/theme/default/images/down.png) |
ajwid01
Messages: 26 Registered: June 2009 Location: UK
|
Junior Member |
|
|
Hi,
I am trying to get a table's specification to implement an auto-increment field based on a sequence lookup.
As I understand it, the pre-requisites for this to be auto-established during the DB Dictionary Import routines is to:
A) Have the PK specified on a numeric column.
B) Have a sequence available following the naming convention <Table_name>_SEQ.
Both these requirements are met, but the table_name.dict.inc does not appear to specify the column as recognised for auto_increment when exported.
Am I doing something wrong?
Best regards,
- Tony.
|
|
|