CREATE TABLE USERS ( 
  USER_ID               NUMBER ( 9 )
     CONSTRAINT US_USER_ID_NN   NOT NULL, 
  USER_EFFECTIVE_DATE   DATE
     CONSTRAINT US_EFFECTIVE_DATE_NN   NOT NULL, 
  SYS_CREATION_DATE     DATE          NOT NULL, 
  SYS_UPDATE_DATE       DATE, 
  OPERATOR_ID           NUMBER ( 9 ), 
  APPLICATION_ID        CHAR ( 6 ), 
  DL_SERVICE_CODE       CHAR ( 5 )      NOT NULL, 
  DL_UPDATE_STAMP       NUMBER ( 4 ), 
  USER_EXPIRATION_DATE  DATE, 
  USER_SHORT_NAME       CHAR ( 20 )
     CONSTRAINT US_SHORT_NAME_NN   NOT NULL, 
  USER_FULL_NAME        CHAR ( 30 )
     CONSTRAINT US_FULL_NAME_NN   NOT NULL, 
  USER_PASSWORD         CHAR ( 12 ), 
  USER_PASWD_EXP_DATE   DATE, 
  USER_OLD_PASSWORD1    CHAR ( 12 ), 
  USER_OLD_PASSWORD2    CHAR ( 12 ), 
  USER_OLD_PASSWORD3    CHAR ( 12 ), 
  USER_OLD_PASSWORD4    CHAR ( 12 ), 
  USER_OLD_PASSWORD5    CHAR ( 12 ), 
  USER_OLD_PASSWORD6    CHAR ( 12 ), 
  USER_OLD_PASSWORD7    CHAR ( 12 ), 
  USER_OLD_PASSWORD8    CHAR ( 12 ), 
  USER_OLD_PASSWORD9    CHAR ( 12 ), 
  USER_OLD_PASSWORD10   CHAR ( 12 ), 
  USER_OLD_PASSWORD11   CHAR ( 12 ), 
  USER_OLD_PASSWORD12   CHAR ( 12 ), 
  USER_LAST_PASWD_IDX   NUMBER ( 2 ), 
  CONSTRAINT USERS_1UQ
    UNIQUE (USER_SHORT_NAME)    USING INDEX 
     TABLESPACE USERS PCTFREE  10 
     STORAGE ( INITIAL 608K NEXT 16K PCTINCREASE  0  ), 
  CONSTRAINT USERS_PK
  PRIMARY KEY ( USER_ID, USER_EFFECTIVE_DATE ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE  10 
     STORAGE ( INITIAL 416K NEXT 16K PCTINCREASE  0  ))
   TABLESPACE USERS
   PCTFREE  10 
   PCTUSED  40 
   INITRANS  1 
   MAXTRANS  255 
 STORAGE ( 
   INITIAL  2179072 
   NEXT  16384 
   PCTINCREASE  0 
   MINEXTENTS  1 
   MAXEXTENTS  400 
   FREELISTS  1  FREELIST GROUPS  1  )
   NOCACHE;