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> execute SYS.DBMS_STATS.gather_table_stats(USER, 'employee_job');
PL/SQL procedure successfully completed.
SQL>
SQL> drop table employee_job;
Table dropped.