Skip to Main Content
Forums

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!

ORA-54020: Virtual column expression cannot be changed because it is a subpartitioning column

S-GeorgeOct 20 2017 — edited Oct 22 2017

Hi all

I am using sub-partition template in one of the tables. The sub-partition is based on a virtual column. Oracle is letting me modify the sub-partition template with a new sub-partition value. When I try to modify the virtual column  I end up getting the following error message,

"ORA-54020: Virtual column expression cannot be changed because it is a subpartitioning column".

If you have come across this problem have you ended up re-creating the table or is there any other way to handle this error?

Please advise.

Thanks,

Sanu
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 19 2017
Added on Oct 20 2017
#sql-pl-sql
8 comments
394 views