Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Automate partition cleanup on partitioned tables
3599652
Member Posts: 4
Add capability to set up retention time frames on partitioned tables so that partitions are automatically dropped or archived off after the retention specified is reached. This would be nice if you could specify a retention period by database, schema or table.
Comments
-
How is this different from the existing ILM features?
-
How is this different from the existing ILM features?
William Robertson wrote:How is this different from the existing ILM features?
ILM doesn't DROP partitions.
AFAIK - The feature to move a tablespace on to/off of TAPE is not yet available.
This may also require editionable tables.
MK