hi,

i created tables and have out data in, them.

Now i want to go back and set primary keys to some of the tables, how do i do this?

i have tried:

SQL> alter table ORGANISATION modify (
2 primary key (orgcode)
3 );
primary key (orgcode)
*
ERROR at line 2:
ORA-02253: constraint specification not allowed here

and I get the above error. what do i do?