0 Replies - 5316 Views - Last Post: 08 December 2012 - 02:23 PM

#1 Saya_26  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 40
  • Joined: 07-November 11

How to add a sequence column to an existing table with records

Posted 08 December 2012 - 02:23 PM

Hello,

I had created a new table named USERLOG with two fields from a previous VIEW. The table already consist of about 9000 records. The two fields taken from the VIEW, i.e. weblog_views consist of IP (consists of IP address), and WEB_LINK (consists of URL). This is the code I used,

CREATE TABLE USERLOG
AS
SELECT C_IP, WEB_LINK FROM weblog_views;


I want to add another column to this table called the USER_ID, which would consists of a sequence starting with 1 to 9000 records to create a unique id for each existing rows. I need help with this part. I'm using Oracle SQL Developer: ODMiner version 3.0.04.
I tried using the AUTO-INCREMENT option,

ALTER TABLE USERLOG 
ADD USER_ID INT UNSIGNED NOT NULL AUTO_INCREMENT;


But I get an error with this,

Error report:
SQL Error: ORA-01735: invalid ALTER TABLE option
01735. 00000 -  "invalid ALTER TABLE option"


So I would really appreciate any help that I can get!

Is This A Good Question/Topic? 0
  • +

Page 1 of 1