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

Breadcrumb

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 100+ 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...

More to Explore

Administration

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