create table test_table_1 (t1_id number(*,0) ,t1_value varchar2(100) ,constraint test_table_1_pk primary key (t1_id) using index); create table test_table_2 (t2_id number(*,0) ,t2_value varchar2(100) ,constraint test_table_2_pk primary key (t2_id) using index); insert into test_table_1 values (1,'Row 1'); insert into test_table_1 values (2,'Row 2'); insert into test_table_1 values (3,'Row 3'); insert into test_table_1 values (4,'Row 4'); insert into test_table_2 values (100,'Row 100'); insert into test_table_2 values (101,'Row 101'); insert into test_table_2 values (102,'Row 102'); insert into test_table_2 values (103,'Row 103');