SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Range Partition on Varchar

PS SPApr 23 2021

Hi All,
I have field "TECH_TIMESTAMP" VARCHAR2(14 CHAR) NOT NULL ENABLE, i want to create range Auto interval partition but I am unable to do it on this varchar.

I have even tried like creating virtual key as "Always As"
ex: "PARTITION_KEY" TIMESTAMP GENERATED ALWAYS AS(TO_TIMESTAMP(TECH_TIMESTAMP, 'yyyy/mm')) VIRTUAL

But this table is getting loaded from different system package. there it's unable to identify the new field.

Thanks

This post has been answered by Solomon Yakobson on Apr 25 2021

Jump to Answer

Added on Apr 23 2021

9 comments

3,098 views