SQL> set linesize 200
SQL> set pagesize 20000
SQL> set autotrace trace
SQL> create table dao_objects as select * from dba_objects ;
Table created.
SQL> set pagesize 20000
SQL> set autotrace trace
SQL> create table dao_objects as select * from dba_objects ;
Table created.
SQL> create index idx_obj_id on dao_objects (object_id) ;
create index idx_obj_type on dao_objects (object_type) ;
Index created.
SQL>
Index created.
SQL> select *
2 from dao_objects do
3 where do.object_id<2000
4 or do.object_type='VIEW';
Ex