CMD tablespace memory issue
Bussiness is currently facing issues with the tablespace, which is used by Marketing Director.
It is almost full and business needs to execute important campaigns with lots of clients. While searching for options to clean up some space they found some tables, which they could not relate to any Object in the Marketing Director.
For example user found 139 table name like CS1602_....., which are using quite much space. But user did not know to which object they belong. According to user knowledge, they suspect it to be belonging to Campaign 1602. But there is no campaign 1602 available anymore.
User seeks support help to know, if it is safe to delete these tables or if they are referenced somehow.
Steps to Reproduce
Below tables are created for trigger segment:
The naming convention for above tables is: CS<seg_id>_<camp_id>_0_<camp_cyc>
Generally it is not recommended to delete above mentioned tables (CSxxx_) manually. It is because, these tables will be left out in Database if the cycle has not yet completed and deleted automatically when the respective cycle completed.
User is suggested to use “Purge Scripts” to delete unused/orphaned objects from CMD schema.
Published November 22, 2016 - Updated December 1, 2016