Connected to Oracle9i Enterprise Edition Release 9.2.0.7.0
Connected as system
SQL>
create table BILL.ACCT_ITEM_TEST
(
ACCT_ITEM_TEST_IDNUMBER(12) not null,
BILL_ID
NUMBER(12),
ACCT_ITEM_TEST_TYPE_ID NUMBER(9) not null,
ACCT_ITEM_TEST_SOURCE_ID NUMBER(9),
BILLING_CYCLE_IDNUMBER(9) not null,
ACCT_ID
NUMBER(12) not null,
SERV_ID
NUMBER(12) not null,
AMOUNT
NUMBER(12) not null,
CREATED_DATEDATE not null,
FEE_CYCLE_IDNUMBER(9) not null,
PAYMENT_METHODNUMBER(9) default 1 not null,
STATE
VARCHAR2(3) not null,
STATE_DATE
DATE not null,
BILL_CYCLE_ID NUMBER(9) not null,
LATE_FEE_DATE DATE,
ITEM_SOURCE_IDNUMBER(9) default -1 not null,
DATA_SOURCE VARCHAR2(3),
BUREAU_ID NUMBER(9) not null,
LATN_ID
NUMBER(9) default 591 not null,
ACCT_ITEM_TEST_CLASS VARCHAR2(1),
PARTNER_ID
NUMBER(9),
MDSE_SPEC_IDNUMBER(9),
PREFER_SPEC_IDNUMBER(9),
ACCESS_CODE_IDNUMBER(9),
PAY_TYPE
VARCHAR2(6),
IF_DEDUCT_OLD_OWE VARCHAR2(1)
)
partition by list (LATN_ID,BILL_CYCLE_ID)
(
PARTITION PART_TEST_591_200701 VALUES LESS THAN (591,200702 ) tablespace TBS_ACCT_ITEM_TEST_DATA
,PARTITION PART_TEST_591_200702 VALUES LESS THAN (591,200703 ) tablespace TBS_ACCT_ITEM_TEST_DATA
,PARTITION PART_TEST_591_200703 VALUES LESS THAN (591,200704 ) tablespace TBS_ACCT_ITEM_TEST_DATA
,PARTITION PART_TEST_591_200704 VALUES LESS THAN (591,200705 ) tablespace TBS_ACCT_ITEM_TEST_DATA
,PARTITION PART_TEST_591_200705 VALUES LESS THAN (591,200706 ) tablespace TBS_ACCT_ITEM_TEST_DATA
,PARTITION PART_TEST_591_200706 VALUES LESS THAN (591,200707 ) tablespace TBS_ACCT_ITEM_TEST_DATA
,PARTITION PART_TEST_591_200707 VALUES LESS THAN (591,200708 ) tablespace TBS_ACCT_ITEM_TEST_DATA
,PARTITION PART_TEST_591_200708 VALUES LESS THAN (591,200709 ) tablespace TBS_ACCT_ITEM_TEST_DATA
,PARTITION PART_TEST_591_200709 VALUES L
ORA-14304: List partitioning method expects a single partitioning column
|
