I have a table who's column have alphanumeric on its value, how could i partition this using oracle?
Our current approach is
CREATE TABLE code_table ( firstchar varchar2(1), secondchar varchar2(1), thridchar varchar2(1), code varchar2(40)) Partition by list (firstchar) ( partition c0 values ('0') tablespace s_ts_02_data, .... partition c9 values ('9') tablespace s_ts_02_data, Partition c10 values ('a','A') tablespace s_ts_02_data, ..... Partition c23 values ('z','Z') tablespace s_ts_02_data );
Is there a better way to do this? And if i want to subpartition secondchar and thirdchar is there a way? Thanks