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

From: <kislam_at_my-dejanews.com>
Date: 1998/09/18
Message-ID: <6tuhs4$kv5$1@nnrp1.dejanews.com>#1/1

Whenever you create a primary key, this create an index by default on it.

In article <6tsamo$8o3$1_at_nnrp1.dejanews.com>, badstreetboy_at_my-dejanews.com wrote:
> 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
>

-----== 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