Technology Stack - EBS (MOSC)

MOSC Banner

How to maintain everything in tablespace APPS_TS_INTERFACE

edited Aug 6, 2012 10:25PM in Technology Stack - EBS (MOSC) 5 commentsAnswered
 Hi,
I would like to know how to maintain table/index in tablespace APPS_TS_INTERFACE.
Because at this time the growth for this tablespace is quite fast.
I need to know if it is possible and safe  to delete the data/index in this tablespace ?

This is the top 10 table/index in my production environtment

    OWNER SEGMENT_NAME         SEGMENT_TYPE SIZ
1 FA         FA_DEPRN_REP_ITF TABLE                 401211392
2 FA         FA_ADDITION_REP_ITF TABLE                 367656960
3 AR         RA_INTERFACE_LINES_ALL TABLE         188874752
4 MRP         MRP_RELIEF_INTERFACE TABLE         78249984
5 APPLSYS AD_TASK_TIMING         TABLE 66060288
6 INV MTL_ITEM_BULKLOAD_RECS  TABLE 61734912
7 AR RA_INTERFACE_SALESCREDITS_ALL TABLE 56229888

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center