- 17.9K All Categories
- 3.3K Industry Applications
- 3.3K Intelligent Advisor
- 60 Insurance
- 534.4K On-Premises Infrastructure
- 137.7K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
What precautions to take to Purge ECBATCHITEMS Table data to free up space it occupies?
We have an issue wherein Enterprise Capture table, ECBATCHITEMS is occupying lots of disk space because there are more than 8 lakh records in it which includes the BLOB content (in ECITEMDATA column).
May of the batches are not released and hence lying up in the table occupying the space.
Is there any way to free up the space occupied by the data in this table?
If we would like to Purge data in this table, than what precautions we need to take care of like Other table dependencies, etc.?
We tried to find out details on Oracle KBase but could not find any details on it .. So, if anybody could detail it out that would be helpful.