row generator
Posted: Tue Sep 19, 2006 8:16 am
I have to populate test data in two tables EMP and DEPT.
Deptno is the FK in EMP table.
First I have populated 10 rows in DEPT table.
Initially Rowgenerator generated 10 rows in dept table with deptno from 0 to 10 and then I have updated deptno with deptno+10.
After that While generating the data in emp tables it gives error:
ORA-02291: integrity constraint
I have to populated many tables like that for test data generation.
Any sugegstion is much appreciated.
Deptno is the FK in EMP table.
First I have populated 10 rows in DEPT table.
Initially Rowgenerator generated 10 rows in dept table with deptno from 0 to 10 and then I have updated deptno with deptno+10.
After that While generating the data in emp tables it gives error:
ORA-02291: integrity constraint
I have to populated many tables like that for test data generation.
Any sugegstion is much appreciated.