Technology Stack - EBS (MOSC)

MOSC Banner

How to archive/purge large data tables

edited Aug 20, 2021 11:55AM in Technology Stack - EBS (MOSC) 3 commentsAnswered

Hi Team,

We have some tables which are grown large in size .

Do we have any purge or archive standard program which can help us here. or any technique which can reduce size of these tables.

INV.MTL_MATERIAL_TRANSACTIONS, AR.RA_CUST_TRX_LINE_GL_DT_ALL, ZX.ZX_LINES_DET_FACTORS, ZX.ZX_LINES, INV.INV.MTL_TRANSACTION_ACS, AP.AP_INVOICE_DTS_ARCH, AR.RA_CUSTOMER_TRX_LINES_ALL, AP.AP_INVOICE_DTRIBUTIONS_ALL, INV.MTL_CST_ACTUAL_COST_DETAILS, GL.GL_IMPORT_REFERENCES

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