Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Table

 

Alter table to add unique with tablespace and storage setting

SQL> SQL> create table employee_job (   2  id                             number                         not null,   3  worker_id                      number                         not null,   4  logical_workplace_id           number                         not null,   5  active_date                    date          default SYSDATE  not null,   6  inactive_date                  date )   7  tablespace USERS pctfree 20   8  storage (initial 10K next 10K pctincrease 0); Table created. SQL> SQL> alter  table employee_job add   2  constraint   employee_job_UK   3  unique (   4  worker_id,   5  active_date )   6  using index   7  tablespace USERS pctfree 20   8  storage (initial 10K next 10K pctincrease 0); Table altered. SQL> SQL> drop table employee_job; Table dropped. SQL>