default values using sequence.netval

Hi guys
I tried to do the following today

sql> create sequence seq1start with 1000;

sql> create table sometable (column1 number(15) not null default seq1.nextval primary key);

oracle returned a error message
ORA-00984: column not allowed here
I am doing something wrong here..

Also when i do something like
SQL> select seq1.nextval , lu_user_id.nextval from dual;

   NEXTVAL NEXTVAL

• ---------- 1000 1000

Am i again doing something wrong..

When i query for the nextval of the sequence 2 times i get the correct 2 different results..

SQL> select lu_user_id.nextval from dual;

   NEXTVAL

      1001

SQL> /    NEXTVAL

      1002

Thanx for u r help Received on Tue Jun 13 2000 - 06:52:21 CDT