SER_BILLS

-- Create table
create table SER_BILLS
(
  STREAMNUMBER       NUMBER(38) not null,
  SERVICEKEY         NUMBER(38),
  CHARGEMODE         CHAR(1),
  CHARGERECORDID     NUMBER(38),
  CALLINGPARTYNUMBER CHAR(24),
  CALLEDPARTYNUMBER  CHAR(24),
  TRANSLATEDPARTYNUM CHAR(24),
  LOCATIONNUMBER     CHAR(4),
  CHARGEDPARTYIDIND  NUMBER(38),
  SPECIFICCHARGEPART CHAR(22),
  STARTDATEANDTIME   CHAR(14),
  STOPDATEANDTIME    CHAR(14),
  DURATION           NUMBER(38),
  CALLCOST           NUMBER(38),
  BEARERCAPABILITY   CHAR(4),
  CHARGECLASS        NUMBER(38),
  SPECIFICCHGPRTTYPE NUMBER(38),
  USERID             NUMBER(38),
  SUBSERVICENUMBER   CHAR(28),
  FEECOUNT           NUMBER(38),
  BASECALLCOST       NUMBER(38),
  EXTRACALLCOST      NUMBER(38),
  CHARGECURRENCY     NUMBER(38),
  TRANSPARENTPARAM   CHAR(40),
  STARTDATETIME      DATE
)
partition by range (STARTDATETIME)
(
  partition DT0 values less than (TO_DATE(' 2009-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace FOREST_DATA
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 64K
      minextents 1
      maxextents unlimited
    )
);
-- Create/Recreate indexes
create index CALLEDPART on SER_BILLS (CALLEDPARTYNUMBER)
  tablespace FOREST_DATA
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
create index STARTDATEPART on SER_BILLS (STARTDATETIME)
  tablespace FOREST_DATA
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );