Oracle gurus - where can I locate TBL$OR$IDX$PART$NUM procedure?
This recursive SQL is executed by SYS during an exchange partition command.
I am trying to locate this TBL$OR$IDX$PART$NUM procedure?
Where is it? How to go about locating it?
SELECT distinct TBL$OR$IDX$PART$NUM("BBUKDW"."VISIT_TX", 0, "CALENDAR_DT")
FROM (SELECT "D"."CALENDAR_DT" CALENDAR_DT FROM "BBUKDW"."JPL_DAY" "D"
WHERE "D"."FINANCIAL_WEEK_ID">=200218 AND "D"."FINANCIAL_WEEK_ID"<=200222)
ORDER BY 1}
What is the goal?
I'm not sure what that is, but may I ask what information you are trying to return? Maybe someone will have another way to get the same data.
It's an undocumented internal function to return the partition number in which a row belongs. You can get some hits by Googling for it.
Click Here to Expand Forum to Full Width