SQL> create index idx_test on test(id1)tablespace IDX nologgin
SQL> create table test as select * from dba_objects where rownum cr
