Data Generator for Oracle doesn't allow to generate data with the same ID
Posted: 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 .
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 .