I am using Oracle 11g database and I have 45 million records. I want to partition the table, but if it's possible for partitioning to support the
like operator then it will be much helpful for me.
In my table one column is
URI, and for that column I want to use the
like operator during partition so that it can help during insertion, because it contains different type of uris such as
I want something like:
CREATE TABLE table_name ( URI varchar2(20); ) PARTITION BY LIST ( URI ) (PARTITION part_mod VALUES (like 'model://%'), PARTITION part_list VALUES (like 'list://%'), PARTITION part_def VALUES (default) );
I tried using Virtual Column-Based Partitioning but didn't get any success. Partitions were created, but during insertion no data is going into corresponding partitions; everything is going into
So is it possible to use the
like operator to partition a table in oracle database?