Optimization issues

Hi.

I have a well designed oracle database with indexes for relationships and most frequent queries. An application with Enterprise Java Beans, modelling a negotiation system is generating data continously (offers, adjudications, and so on).

But the application needs only 2 months of contingency-data, so we want to optimize access for those records. The first approach is straightforwardly to delete all older records, but it seems to be not the rigth solution, the database must needs a backup every time the delete operation is executed, and the import operation will be a very hard issue.

Another approach is to partition tables, but all tables will need a "separation attribute", and we need also a fix-process to set the separation attribute. We also needs to update all queries to be suitable for the new table-structure, and reconsider all indexes.

Is there any other approach wich implies not to change schema structures?
Is there a backup method or a backup approach for those systems types?

Thanks in advance.

Ismael. Received on Thu Apr 05 2001 - 16:48:51 CDT