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);

-------------------------------------------------------
'Life always gives you back what you give out. Our life is not a coincidence,
but a mirror of our own doings.'

Oracle LazyDBA home page