In the below table my partition key is doc_type which datatype is varchar.If i do the partition with datatype as varchar i am getting an below error .But for the same with numbers it is getting created .How should i creat this table as partitioned with the same values with datatype as varchar2(5)
SQL> @part
SQL> CREATE TABLE PART_DOCUMENT
2 (
3 BATCH_NAME VARCHAR2(50) NULL,
4 RELEASE VARCHAR2(100) NULL,
5 FILENAME VARCHAR2(50) NULL,
6 RELEASE_DATE DATE NULL,
7 COMPASS_ACCT VARCHAR2(10) NULL,
8 ACCOUNT_NUMBER VARCHAR2(26) NULL,
9 DOC_TYPE number(5) NULL,
10 CUST_NAME VARCHAR2(30) NULL,
11 VIN VARCHAR2(20) NULL
12 )
13 TABLESPACE GENERAL_DATA
14 PARTITION BY RANGE(DOC_TYPE)
15 (PARTITION P1 VALUES LESS THAN (11),
16 PARTITION P2 VALUES LESS THAN (30),
17 PARTITION P3 VALUES LESS THAN (40),
18 PARTITION P4 VALUES LESS THAN (50),
19 PARTITION P5 VALUES LESS THAN (70),
20 PARTITION P6 VALUES LESS THAN (100),
21 PARTITION P7 VALUES LESS THAN (101),
22 PARTITION P8 VALUES LESS THAN (102),
23 PARTITION P9 VALUES LESS THAN (103),
24 PARTITION P10 VALUES LESS THAN (104),
25 PARTITION P11 VALUES LESS THAN (105),
26 PARTITION P12 VALUES LESS THAN (106),
27 PARTITION P13 VALUES LESS THAN (501),
28 PARTITION P14 VALUES LESS THAN (maxvalue))
29 /

Table created.

SQL> CREATE TABLE FMCCDBA.PART_DOCUMENT_a
2 (
3 BATCH_NAME VARCHAR2(50) NULL,
4 RELEASE VARCHAR2(100) NULL,
5 FILENAME VARCHAR2(50) NULL,
6 REL_DATE DATE NULL,
7 COMPASS_ACCT VARCHAR2(10) NULL,
8 ACC_NUMBER VARCHAR2(26) NULL,
9 DOC_TYPE varchar(5) NULL,
10 CUST_NAME VARCHAR2(30) NULL,
11 VIN VARCHAR2(20) NULL
12 )
13 TABLESPACE GENERAL_DATA
14 PARTITION BY RANGE(DOC_TYPE)
15 (PARTITION P1 VALUES LESS THAN (11),
16 PARTITION P2 VALUES LESS THAN (30),
17 PARTITION P3 VALUES LESS THAN (40),
18 PARTITION P4 VALUES LESS THAN (50),
19 PARTITION P5 VALUES LESS THAN (70),
20 PARTITION P6 VALUES LESS THAN (100),
21 PARTITION P7 VALUES LESS THAN (101),
22 PARTITION P8 VALUES LESS THAN (102),
23 PARTITION P9 VALUES LESS THAN (103),
24 PARTITION P10 VALUES LESS THAN (104),
25 PARTITION P11 VALUES LESS THAN (105),
26 PARTITION P12 VALUES LESS THAN (106),
27 PARTITION P13 VALUES LESS THAN (501),
28 PARTITION P14 VALUES LESS THAN (maxvalue))
29 Input truncated to 1 characters
/
PARTITION P5 VALUES LESS THAN (70),
*
ERROR at line 19:
ORA-14037: partition bound of partition "P5" is too high


SQL> spool off