怎么在一个已经建好的表里面实现oracle 10g 修改主键为自增字段？？？小小菜鸟，求步骤！

---

oracle没有自增的

要建个序列源基和建个触发器实橡型现

--建序列
CREATE SEQUENCE "CLIENT_SQ";

--建触发器

CREATE OR REPLACE TRIGGER "CLIENT_TR"
BEFORE INSERT ON "CLIENT"雹如谨
FOR EACH ROW
WHEN (new."ID" IS NULL)
BEGIN
SELECT "CLIENT_SQ".nextval
INTO :new."ID" FROM dual;
END;
/

---