Home » SQL & PL/SQL » SQL & PL/SQL » recycle bin
recycle bin [message #188110] Thu, 17 August 2006 02:55 Go to next message
Messages: 112
Registered: July 2006
Senior Member

I have a procedure which takes two days altogether. During this process, a lot of temporary files are created and deleted.
Is it neccessary that I purge the recycle bin periodically? Would it be good to run a job parallel to the whole procedure which just cleanes the recycle bin all few seconds?

Re: recycle bin [message #188111 is a reply to message #188110] Thu, 17 August 2006 03:00 Go to previous message
Messages: 21130
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As you mention temporary FILES, I guess it is about your operating system Recycle Bin, not Oracle's. If so, there's no need to do anything about it - recycle bin has limited size and, when exceeded, files are automatically deleted from it (should be FIFO).
Previous Topic: Help querying status changes
Next Topic: Need help for updating table records
Goto Forum:

Current Time: Tue Jul 25 16:07:28 CDT 2017

Total time taken to generate the page: 0.05567 seconds