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?