I have a partitioned table which I populated with data but forgot to add one column. So I added the missing column but now that column is null. Could someone please advise the syntax to populate all 2000 rows of that column with the number 60?
alter table sgsn_mobility_mgmt_index set PERIOD_DURATION=60
but get message 'Missing keyword UNUSED'
insert into sgsn_mobility_mgmt_index (PERIOD_DURATION) values (60)
but get message 'Inserted partition key does not map to any partition'.