Re: difference between table default oracle and table for user transactions

Posted by ErmanArslansOracleBlog on Oct 23, 2017; 9:02am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/difference-between-table-default-oracle-and-table-for-user-transactions-tp4084p4146.html

Okay, you need EBS archiving..

You can't just delete rows from the tables.
Move data from one instance to another partially and so on..
These are unsupported things..

But what you can do is EBS archiving.

Clone your environment to have an exact copy of PROD instance.
Then plan to implement archiving on PROD -> Reducing Your Oracle E-Business Suite Data Footprint using Archiving, Purging, and Information Lifecycle Management (Doc ID 752322.1). There is a pdf attached to this note, please review it.