Is anybody familiar with hash function oracle used to determine the hash value in case of hash partitioning.
e.g. for a table is partioned into 4 hash partitions and key is number data type, which values will go to Partition 1, 2 ,3 and 4. I tried inserting continous set of values from 1000,...., 1014. But I could not figure out the logic.
Second question would be what would be logic of varchar key etc.???
Any input would be appreciated.
e.g. for a table is partioned into 4 hash partitions and key is number data type, which values will go to Partition 1, 2 ,3 and 4. I tried inserting continous set of values from 1000,...., 1014. But I could not figure out the logic.
Second question would be what would be logic of varchar key etc.???
Any input would be appreciated.