drop table t1

drop table t2

create table t1 as  
select object_id id1, data_object_id id2  
from   all_objects where object_id is not null

alter table t1 add constraint t1_pk primary key (id1)

create index t1_i1 on t1 (id2)

create table t2 as  
select id1, id2   
from   t1

create index t2_i1 on t2 (id2)