When we ran the sql created by the CS Framework install one of the commands failed as you can't alter a table with values in it.

ALTER TABLE SSWMD01.pc_data_workattach MODIFY “PXATTACHKEY” DATE

This is problematic for us as the table in production has over 66 million rows. What is the Pega recommendation (this is an oracle database) for the most efficient way of getting this table's column changed from varchar to date?

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.