When you specified column f1 as the primary key an index was created on that
column, so when you attempt to create an index on the same column ORACLE
prevents it and issues the ORA-1408 message.
badstreetboy_at_my-dejanews.com wrote in message
<6tsamo$8o3$1_at_nnrp1.dejanews.com>...
>I try to create a table by:
>
>CREATE TABLE t1(
> f1 INTEGER NOT NULL PRIMARY KEY,
> f2 INTEGER NOT NULL);
>CREATE INDEX f1_index ON t1(
> f1);
>
>Then it gives me an err:
>
>ERROR at line 2:
>ORA-01408: such column list already indexed
>
>Why this happen? I would appreciate if anyone can help me. Thanks!
>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Sep 18 1998 - 00:00:00 CDT
