Hello everyone,
Is it possible to have a table/index partitioned/subpartitioned based on different number of columns and partition type (list,hash range) of combinations.
Something like ...
I have the following table.
create table test_part
(p_no number,
c_no number,
r_no number,
val number,
sal number);
While creating this table need to have it partitioned based on different types of createria as in DB2.
Want that partition to be based on columns p_no, c_no, r_no .
Need to have 4 partitions based on the following criterias. Values or given in the order p_no, c_no, r_no .
Part 1 ---> 1,2,anything
part 2 ----> 1,anything otherthan 2, anything
part 3 ---> 2,substr(c_no,1,1) = 2,3
part 4 ---> 3,5,8
It can be on index or on table. Partition with multiple subpartitions or anything.
But records needs to be placed in four different tablespaces based on the defined condition.
We are working on a DB2 - oracle migration. Client want us to replicate the structures as same as in DB2. They are not bothered about the performance since it is going to be a kind of archival to them
Is it possible in oracle. If yes can I have some samples please.
Thanks in Advance,
Jaggyam