| Step for Purge Data [message #170159] |
Tue, 02 May 2006 07:27  |
voralux
Messages: 72
Registered: January 2006
|
Member |
|
|
I have plan for purge data.
Please list step process and step check data for "Purge" : GL, AP(PO), OM, INV, AR, FA
Thank you
|
|
|
|
| Re: Step for Purge Data [message #170216 is a reply to message #170159] |
Tue, 02 May 2006 11:49  |
adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway
|
Senior Member |
|
|
How this is done is described in the user guides for the applications you mentioned. These can be downloaded from the Oracle Technology Network. Before purging production data be sure that you do not purge any data that has not been archived and which you required by law to have on hand.
Some people find the standard purging functionality in Oracle and use third-party solutions provided by companies such as OuterBay and Applimation.
--
Aleksander Dragnes
|
|
|
|
|
|
| Re: Step for Purge Data [message #170315 is a reply to message #170292] |
Wed, 03 May 2006 05:01 |
adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway
|
Senior Member |
|
|
I assume the reason you want to purge data is to limit the growth of your database. Given that it would make sense to start with the application with the most transactions. What that application is depends almost entirely on you organisation. You could try finding what tablespace is the largest and starting with the corresponding application.
--
Aleksander Dragnes
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
