SQL>
SQL> create table lookup_heap(
2 key_col primary key,
3 key_val
4 )as
5 select object_name, max( owner||'_'||object_id )from all_objects group by object_name
6 /
Table created.
SQL>
SQL> drop table lookup_heap;
Table dropped.
SQL>