Re: Why I can't have primary key on field that has index?

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: 1998/09/17
Message-ID: <6tsg1t$b25@sjx-ixn3.ix.netcom.com>#1/1

If you specify the column to be a primary key, oracle will automatically create an unique index on that column. That is the reason you get that error

Winnie

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 Thu Sep 17 1998 - 00:00:00 CDT