topic Re: Generate an auto increment primary key in Oracle in Talend Studio

Generate an auto increment primary key in Oracle

Anonymous — Fri, 29 Jul 2016 11:38:21 GMT

I want to create a primary key auto increment under oracle!
I had created an output table (Oracle) and I want to add an automatic primary key! how can I do that ?

Re: Generate an auto increment primary key in Oracle

Anonymous — Fri, 29 Jul 2016 12:04:12 GMT

Use an oracle sequence. This demonstrated reasonably well here ( https://help.talend.com/search/all?query=Using+an+Oracle+sequence+while+inserting+data&content-lang=en)

Re: Generate an auto increment primary key in Oracle

Anonymous — Fri, 29 Jul 2016 14:28:38 GMT

Thanks for your reply but it doesn't work ! I get this error
ORA-00957: duplicate column name

Re: Generate an auto increment primary key in Oracle

Anonymous — Fri, 29 Jul 2016 23:26:56 GMT

You are adding an extra ID column. Your schema already includes it and you are adding a new one with your advanced settings. Change the "Before" to "Replace" in the advanced settings.

Re: Generate an auto increment primary key in Oracle

Anonymous — Sat, 30 Jul 2016 09:47:02 GMT

Even when I change the "Before" to "Replace", I still get the same error 😕

Re: Generate an auto increment primary key in Oracle

Anonymous — Sat, 30 Jul 2016 14:38:36 GMT

Simply set the ID column in the schema as inactive or better remove it.

Re: Generate an auto increment primary key in Oracle

Anonymous — Sat, 30 Jul 2016 14:45:42 GMT

You need to change "Colonne de ref" to "ID" if you haven't. You are essentially replacing the value that would have been placed in this column with the next value of the sequence.
EDIT: ....or do what Jlolling said. Either will work