Oracle8 Archive process

From: <hr784_at_cleveland.freenet.edu>
Date: 1998/08/24
Message-ID: <6rs7dg$7bn$1@nnrp1.dejanews.com>#1/1

I'm running some PLSQL code that processes a raw ascii file and loads into our Oracle8 database. This process doesn't use Oracle SQL Loader. I need PLSQL to process these files that are sent by my customer for processing speed.

The problem is that the Archive logger is on and I can generate around 4 gig of archive files on any specific load. I can't turn archiving off since a load can happen any time of day.

Does anyone know how to turn archiving off for a specific process without turning it off for the whole SID? SQL Loader does this with the unrecoverable option.

Any Ideas???????

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Aug 24 1998 - 00:00:00 CDT