SQL & PL/SQL

Create an Index on the fields cus_surname, and cus_firstname. Index Detail: Clustered unique on the combination

CREATE UNIQUE CLUSTER INDEX index_name
ON CUSTOMER(CUS_SURNAME, CUS_FIRSTNAME);

Error report:
SQL Error: ORA-00968: missing INDEX keyword
00968. 00000 - "missing INDEX keyword"


I dont know what the Syntax for creating a clustered unique index. I've searched google and all i could find was a Unique Index.


e.g.

CREATE [UNIQUE] INDEX index_name
ON table_name (column1, column2, . column_n)
[ COMPUTE STATISTICS ];

http://www.techonthenet.com/oracle/indexes.php


Thanks,
mc