Page 1 of 1

Data Generator for Oracle doesn't allow to generate data with the same ID

Posted: Tue 12 Apr 2016 18:00
by renatohlf
dbForge data Generator for Oracle doesn't allow to generate data with the same 'ID'.

I have a table 'Receipt'. Columns: id_doc and tx_barcode.
this table allows to create many tx_barcode with the same id_doc.
I tried to do this in dbForge, but it doesn't allow.

The column in the database is not unique but dbforge understands that it is unique and won't let us change.

this table just has two columns:
id_doc-> unique(just on dbforge) -> not null
tx_barcode -> unique(just on dbforge) -> not null

*On my DataBase these colmuns aren't unique.

When I tried to click on table, to generate 20 rows to the same ID_doc, the preview shows just one row to be inserted, instead of 20 rows.
"Preview of data to be generated (first 1 rows of 20)"
ID_doc| tx_barcod
1 551BARCOD


*On my oracle DB
select * from table_name where id_doc = 1;
brings:
ID_doc| tx_barcod
1 530BARCOD
1 431BARCOD
1 352BARCOD


I searched for this solution in documentation , and videos or comments and I found nothing .

Re: Data Generator for Oracle doesn't allow to generate data with the same ID

Posted: Wed 13 Apr 2016 08:38
by alexa
Could you please provide us the CREATE definition of the table?

You can reply straight to our support system at supportATdevartDOTcom

Re: Data Generator for Oracle doesn't allow to generate data with the same ID

Posted: Fri 29 Apr 2016 18:06
by renatohlf
create table renatohenrique ( prk number(19) not null, name varchar2(50) not null, constraint chave_pr primary key (prk,name) );

It's a composite key.

I would like to create some records for the created table, with the same PRK, changing only the field "name".
This is possible, because the key is a composite key. What I can't have are two identical records(that is, with the same PRK and the same "name").

What happens in DBForge DataGenerator for Oracle:
It identifies each one of these fields as unique, making it impossible to create several records with the same PRK. In Dbforge, In the "Fill settings" area, the checkbox "Set to be unique" is marked and disabled, in a way that it doesn't let me unmark.

Thanks in advance.

Re: Data Generator for Oracle doesn't allow to generate data with the same ID

Posted: Wed 04 May 2016 09:42
by alexa
We haven't supported the ability to work with a composite PK yet in DBForge. This is to be supported in one of the next product versions.