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

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