All Questions
2 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 ...
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 :...