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

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
renatohlf
Posts: 2
Joined: Tue 12 Apr 2016 17:06

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

Post by renatohlf » Tue 12 Apr 2016 18:00

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 .

alexa
Devart Team
Posts: 2502
Joined: Fri 24 Jun 2011 14:17

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

Post by alexa » Wed 13 Apr 2016 08:38

Could you please provide us the CREATE definition of the table?

You can reply straight to our support system at supportATdevartDOTcom

renatohlf
Posts: 2
Joined: Tue 12 Apr 2016 17:06

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

Post by renatohlf » Fri 29 Apr 2016 18:06

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.

alexa
Devart Team
Posts: 2502
Joined: Fri 24 Jun 2011 14:17

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

Post by alexa » Wed 04 May 2016 09:42

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.

Post Reply