Differences between purge and delete files?

oracle file unix purge
Jay picture Jay · Aug 23, 2012 · Viewed 13.2k times · Source

I have looked it up but haven't been able to find many differences between purging and deleting a set of files. Is there more to PURGE than simply BACKUP AND DELETE?

EDIT: Specifically, this is about trace files and log files in Oracle

Answer

Chao picture Chao · Aug 16, 2013

Purge runs on a regular basis. It delete things that marked as delete. You can set up criteria. For example, you can set criteria that to remove all the rows have a flag as delete, and remove those rows from a table.

Delete removes the rows on going. For example, if you have a work queue, and the tasks will be finished after the queue, you can delete those rows since they are not needed anymore.

Related questions

Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More