Skip to main content

All Questions

1 vote
0 answers
2k views

Looping in an oracle table based on partitions

I am creating a Query which is taking data from multiple other databases through DBlinks. One of the table "ord" in a Query is immensely large , say more than 50 million rows. Now, I want to create ...
Incredible's user avatar
9 votes
5 answers
36k views

how to find partition of record oracle

I have a table and there is a partition on it. There are 16 hash partition which is starting from SUBSCRIBER_01 .. etc Table name: SUBSCRIBER Partition Column: CUSTOMER_ID (VARCHAR2 10) Database :...
Mehmet's user avatar
  • 2,288