Mass updates in Oracle?

Now that our mainframe to unix conversion is complete, we are wanting to port some batch applications from COBOL/Simulated VSAM to C/Oracle V7.

Specifically, we have an app, that for other reasons, necessitates a ground up rewrite; seems like a good time to get off of COBOL.

The data processing will involve loading 250-1200 meg/day into the database, processing it, and then deleting it the next day before the run. It seems to me that most of the work will not need the rollback capabilities of Oracle (loading and deleting the data), but the rollback stuff seems to add a significant performance penalty.

Can I tell Oracle V7, "Look, I don't care if you can't roll it back. If the run fails, I'll rerun it, so don't attempt rollback."?

I could preprocess the data for SQL-Load, drop then create the tables, then load using the fast-path thingamabob, but then I'd have to stage the data several times on our system (Tape->Preprocessed->Oracle). I'd also lose the ability to manipulate part of the tables; I'd have to drop/create entire tables. Ideally, we could put all four of our customer's data in the same tables (differentiated by a field), but manipulate a customer's data individually.

Any insight would be greatly appreciated.

Thanx,
Marty Received on Thu Jun 02 1994 - 05:32:35 CEST