Skip to Main Content
  • Questions
  • Mapping system GENERATED PARTITION names


Question and Answer

Connor McDonald

Thanks for the question, Paul.

Asked: November 17, 2021 - 11:05 am UTC

Last updated: November 18, 2021 - 3:18 am UTC

Version: 19.2

Viewed 1000+ times

You Asked

I recently converted a few tables to use INTERVAL PARTITIONs, which worked fine.

Since the conversion the PARTITION names have changed to SYS_####. Unbeknownst to me I found there were some applications, which were referencing partitions by names (as ridiculous as it sounds) ie SELECT count(*) from table partition P_MMDDYYYY ), which no longer works.

Is there some sort of function or procedure that I can give these developers that can map a system GENERATED PARTITION name back to the format P_MMDDYYYY as I'm getting blow back because some still insist on using the PARTITION name).

and Connor said...

Is this answer out of date? If it is, please let us know via a Comment

More to Explore


Need more information on Administration? Check out the Administrators guide for the Oracle Database