At our office we have an application that runs many aspects of the business. This software runs on Oracle 9i - to report on this data we use Crystal Reports to execute a Stored Procedure that returns data for display.
The stored procedure works but delteing data from a table and then populating the table with data. Manipulation is done as data is added to the table etc.. My problem is that this casues a lot of disk thrashing on the server. This morning we had an error that we had filled our ROLLBACK space on the server. Clearly what Oracle is doing is providing/storing rollback information for all the tables in the databse including the temporary ones that are used for the reports.
Therefore I want to disable Oracle from storing rollback either on that table or a way in which I can disable it on the following SQL statements. We just don't need the rollback on these tables.
Any help on this greatly appreciated.