Grzegorz Michalski
b96becd8ef
Add autonomous transaction pragma to ARCHIVE_TABLE_DATA and GATHER_TABLE_STAT procedures for improved transaction handling
2026-02-11 07:36:52 +01:00
Grzegorz Michalski
b1bb24e487
Refactor file retrieval logic in ARCHIVE_TABLE_DATA and GATHER_TABLE_STAT procedures to simplify queries and enhance clarity
2026-02-10 14:03:52 +01:00
Grzegorz Michalski
86535048fc
Add TRASH folder management procedures for restoring and purging files
2026-02-10 13:53:12 +01:00
Grzegorz Michalski
9ffad718fe
Update FILE_ARCHIVER package to version 3.2.1, fixing status update from ARCHIVED to ARCHIVED_AND_TRASHED for files moved to TRASH folder
2026-02-10 13:18:17 +01:00
Grzegorz Michalski
6c8b22eac9
Add DATA_EXPORTER package and update installation scripts for export registration
...
- Created new package CT_MRDS.DATA_EXPORTER (v2.6.3) for comprehensive data export capabilities, including CSV and Parquet formats with OCI integration.
- Implemented version history tracking and enhanced error handling for export processes.
- Updated installation scripts to include pRegisterExport parameter for registering exports in A_WORKFLOW_HISTORY and A_SOURCE_FILE_RECEIVED.
2026-02-10 09:33:46 +01:00
Grzegorz Michalski
d443c4f07d
Update FILE_ARCHIVER package to version 3.2.0 with TRASH retention control and new statuses
2026-02-10 08:23:06 +01:00
Grzegorz Michalski
70909ba8c4
Enhance FILE_ARCHIVER package to include ODS bucket URI retrieval and update insert statements for A_TABLE_STAT_HIST and A_TABLE_STAT
2026-02-09 13:42:50 +01:00
Grzegorz Michalski
88325f0b8c
Refactor FILE_ARCHIVER package to use CT_MRDS.ENV_MANAGER consistently for logging and parameter formatting
2026-02-09 11:04:33 +01:00
Grzegorz Michalski
dc8031262c
konfiguracja
2026-02-09 10:22:38 +01:00
Grzegorz Michalski
fc95b12c9e
Remove test scenarios for archival strategies from test_archival_strategies.sql
2026-02-09 09:40:31 +01:00
Grzegorz Michalski
23b9962128
Update ARCHIVE_TABLE_DATA procedure to use GROUP BY instead of DISTINCT to resolve ORA-22950 issue
2026-02-09 09:36:05 +01:00
Grzegorz Michalski
802c102f29
Refactor archival strategy logic in FILE_ARCHIVER package to enhance clarity and support for age-based archiving
2026-02-09 09:12:49 +01:00
Grzegorz Michalski
fa1f179be9
gitignore
2026-02-09 08:13:26 +01:00
Grzegorz Michalski
974f6eca25
Update FILE_ARCHIVER package to version 3.1.2 with enhanced archival strategies and fixes
2026-02-06 11:45:57 +01:00
Grzegorz Michalski
c4f5ba48bc
wk
2026-02-06 11:41:25 +01:00
Grzegorz Michalski
e6ab189dc9
Refactor archival strategies in FILE_ARCHIVER package
...
- Removed CURRENT_MONTH_ONLY strategy, replacing it with MINIMUM_AGE_MONTHS = 0 for current month retention.
- Updated validation logic to allow MINIMUM_AGE_MONTHS to be non-negative.
- Consolidated documentation to reflect changes in archival strategies.
- Adjusted rollback script to reset all archival parameters to NULL for 25 Release 01 tables.
- Enhanced README and installation scripts to clarify new configuration requirements and usage examples.
- Updated version history to indicate breaking changes and migration steps for existing configurations.
2026-02-05 20:17:51 +01:00
Grzegorz Michalski
e93140e962
zmiany w pakiecie
2026-02-05 11:03:15 +01:00
Grzegorz Michalski
569c647b6c
dopracowanie paczki
2026-02-04 12:22:33 +01:00
Grzegorz Michalski
c508e1e4e2
Refactor archival strategy rollback scripts for Release 01 tables
2026-02-03 19:39:08 +01:00
Grzegorz Michalski
d6fd0b3dbd
Add scripts for configuring and rolling back archival strategies for Release 01 tables
2026-02-03 19:02:32 +01:00
Grzegorz Michalski
76c8ce6cc7
change rollback folder name
2026-02-03 14:00:47 +01:00
Grzegorz Michalski
64965fb8c8
MARS-828
2026-02-03 13:51:13 +01:00
Grzegorz Michalski
e3ff1618ce
Przeniesienie
2026-02-03 13:32:06 +01:00
Grzegorz Michalski
00063f1d0b
Mearge recent development
2026-02-02 11:18:42 +01:00
Grzegorz Michalski
ffcb288afa
Develop
2026-02-02 11:13:24 +01:00
Grzegorz Michalski
ecd833f682
Init
2026-02-02 10:59:29 +01:00
