Can we drop APPS_TS_SUMMARY tablespace and generate the data again (using adadmin, concurrent progra
Hi,
We lost one datafile from APPS_TS_SUMMARY tablespace and we do not have backup for it.
As per the documentation it stores summary information like Materailzed view and MaterailzedView log etc.
Can we drop APPS_TS_SUMMARY tablespace and generate the data again (using adadmin, concurrent program, plsql etc.)
I found, for example, there are two tables in this tablespace.
1.PA_PROJECT_ACCUM_BUDGETS , which can be populated by "PRC: Update Project Summary Amounts"
2.AP_LIABILITY_BALANCE, which can be populated by "Insert_AP_Liability_Balance"
Please suggest.