create tablespace tabspace_2
datafile 'file_on_disk2';

create index ind_1 on tabl_1(col_1)
tablespace tabspace_2;

- 복합 인덱스
create index deptno_job_idx on big_emp (job, deptno);
select ename from big_emp
where job='ANALYST' and deptno=20 ;