Hello dmarian,

According to the DBA handbook it must be something like:

CREATE TABLE EMPLOYEES
(
EMPID NUMBER(10),
LASTNAME VARCHAR2(25) NOT NULL,
FIRSTNAME VARCHAR2(25) NOT NULL,
CONSTRAINT PK_EMPLOYEES_01
PRIMARY KEY (EMPID),
DISABLE CONSTRAINT PK_EMPLOYEES_01
);

But this does not work on my 8.0.5 database?

Have to try it on a 8.1.5 @ home.
(Using partitioning there is also a posibility of enabling/disabling row movement)

tycho