27 lines
1.5 KiB
SQL
27 lines
1.5 KiB
SQL
|
|
alter table CT_MRDS.A_TABLE_STAT RENAME COLUMN OVER_HIST_THRESOLD_FILE_COUNT TO OVER_ARCH_THRESOLD_FILE_COUNT;
|
|
alter table CT_MRDS.A_TABLE_STAT RENAME COLUMN OVER_HIST_THRESOLD_ROW_COUNT TO OVER_ARCH_THRESOLD_ROW_COUNT;
|
|
alter table CT_MRDS.A_TABLE_STAT RENAME COLUMN OVER_HIST_THRESOLD_SIZE TO OVER_ARCH_THRESOLD_SIZE;
|
|
alter table CT_MRDS.A_TABLE_STAT RENAME COLUMN HIST_THRESHOLD_DAYS TO ARCH_THRESHOLD_DAYS;
|
|
|
|
alter table CT_MRDS.A_TABLE_STAT_HIST RENAME COLUMN OVER_HIST_THRESOLD_FILE_COUNT TO OVER_ARCH_THRESOLD_FILE_COUNT;
|
|
alter table CT_MRDS.A_TABLE_STAT_HIST RENAME COLUMN OVER_HIST_THRESOLD_ROW_COUNT TO OVER_ARCH_THRESOLD_ROW_COUNT;
|
|
alter table CT_MRDS.A_TABLE_STAT_HIST RENAME COLUMN OVER_HIST_THRESOLD_SIZE TO OVER_ARCH_THRESOLD_SIZE;
|
|
alter table CT_MRDS.A_TABLE_STAT_HIST RENAME COLUMN HIST_THRESHOLD_DAYS TO ARCH_THRESHOLD_DAYS;
|
|
---
|
|
alter table CT_MRDS.A_SOURCE_FILE_CONFIG RENAME COLUMN DAYS_FOR_HISTORY_THRESHOLD TO DAYS_FOR_ARCHIVE_THRESHOLD;
|
|
alter table CT_MRDS.A_SOURCE_FILE_CONFIG RENAME COLUMN FILES_COUNT_OVER_HISTORY_THRESHOLD TO FILES_COUNT_OVER_ARCHIVE_THRESHOLD;
|
|
alter table CT_MRDS.A_SOURCE_FILE_CONFIG RENAME COLUMN BYTES_SUM_OVER_HISTORY_THRESHOLD TO BYTES_SUM_OVER_ARCHIVE_THRESHOLD;
|
|
alter table CT_MRDS.A_SOURCE_FILE_CONFIG RENAME COLUMN ROWS_COUNT_OVER_HISTORY_THRESHOLD TO ROWS_COUNT_OVER_ARCHIVE_THRESHOLD;
|
|
|
|
alter table CT_MRDS.A_SOURCE_FILE_RECEIVED RENAME COLUMN HIST_FILE_NAME TO ARCH_FILE_NAME;
|
|
|
|
UPDATE "CT_MRDS"."A_FILE_MANAGER_CONFIG"
|
|
SET CONFIG_VARIABLE = 'ArchiveBucketName'
|
|
WHERE CONFIG_VARIABLE = 'HistoryBucketName';
|
|
|
|
commit;
|
|
|
|
|
|
|