Question

1
Replies
69
Views
Close popover
Mark Huseboe (MarkH960)
Ameriprise Financial

Ameriprise Financial
US
MarkH960 Member since 2012 46 posts
Ameriprise Financial
Posted: November 16, 2016
Last activity: April 6, 2018
Closed

CS Framework issue

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.

System Administration Upgrades
Moderation Team has archived post