Create index with tablespace : Create Index « Index « Oracle PL/SQL Tutorial

SQL> create table emp (
  2      EmpNo          NUMBER(10) primary key,
  3      Name           VARCHAR2(40),
  4      DeptNo         NUMBER(2),
  5      Salary         NUMBER(7,2),
  6      Birth_Date     DATE,
  7      Soc_Sec_Num    VARCHAR2(9),
  8      State_Code     CHAR(2)
  9  );
SQL>
SQL> create index CITY_ST_ZIP_NDX
  2  on emp(EmpNo, DeptNo, Soc_Sec_Num)
  3  tablespace INDEXES;



SQL>
SQL> drop table emp
  2

9.1.Create Index
	9.1.1.	Creating an Index
	9.1.2.	Enforce uniqueness of values in a column using a unique index
	9.1.3.	Create combined-column index
	9.1.4.	Create a composite index on multiple columns
	9.1.5.	Creating a Function-Based Index
	9.1.6.	Create index based on cluster
	9.1.7.	Creates an index on the new added column
	9.1.8.	Create a fully indexed table named myCode
	9.1.9.	indextype is ctxsys.context
	9.1.10.	Create index for upper case last name
	9.1.11.	Create index along with the column definition
	9.1.12.	Create index for combined columns
	9.1.13.	Create unique index and check it in user_ind_columns and user_cons_columns
	9.1.14.	Demonstrate a bitmap join index.
	9.1.15.	create unique index with case ... when statement
	9.1.16.	Create Non-Unique index
	9.1.17.	autotrace ctxsys.context index
	9.1.18.	Create index with tablespace