Data Generator

[Amila Fernando]

Hello,

I have investigating the usage of Data Generator for some of the development task, just populating one table seems to be okie. I got problem with MASTER DETAILS table

Following are the two DDL statement for create tables

CREATE TABLE supplier_info_amfelk_tab
(
supplier_id varchar2(50) not null,
supplier_name varchar2(100) not null,
contact_name varchar2(50)
)
tablespace XXXX_DATA
pctfree 0
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);

alter table supplier_info_amfelk_tab
add constraint supplier_info_amfelk_pk primary key (supplier_id)
using index
tablespace XXXX _INDEX
pctfree 0
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);

CREATE TABLE products_info_amfelk_tab
(
product_id varchar2(50) not null,
supplier_id varchar2(50) not null,
supplier_name varchar2(100) not null,
product_name varchar2(100)
)
tablespace XXXX _DATA
pctfree 0
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);

alter table products_info_amfelk_tab
add constraint products_info_amfelk_pk primary key (product_id)
using index
tablespace XXXX _INDEX
pctfree 0
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);

ALTER TABLE products_info_amfelk_tab
add CONSTRAINT supplier_info_amfelk_fk
FOREIGN KEY (supplier_id)
REFERENCES supplier_info_amfelk_tab(supplier_id);

So I created these two tables in way that products_info_amfelk_tab table appeared as child table of the supplier_info_amfelk_tab . Now I want to populate the products_info_amfelk_tab table while setting the supplier_info_amfelk_tab as master table. But when I going to do that I couldn

 

[Marco Kalter]

Does the master table already contain data, or should the Data Generator populate that table as well?