Hi, Ramki, the CREATE CLUSTER is only the first of, at least, 4
DDL statements you are supposed to issue.

1. CREATE CLUSTER emp_dept ...
2. CREATE INDEX <index_name> ON CLUSTER emp_dept...
3. CREATE TABLE emp (...) CLUSTER emp_dept(dept_no);
4. CREATE TABLE dept (...) CLUSTER emp_dept(dept_no);

HTH.

James

> Hi All
>
> The below statement is oracle 8i doc it says this command creates
> the Cluster on the emp table and dept table since the table info is
> not specified how can one know exactly
>
> Thanx in advance
>
> Ramki
>
> CREATE CLUSTER emp_dept (deptno NUMBER(3))
> PCTUSED 80 PCTFREE 5 SIZE 600 TABLESPACE users
> STORAGE (INITIAL 200K NEXT 300K MINEXTENTS 2 MAXEXTENTS 20
> PCTINCREASE 33);
>
Oracle LazyDBA home page