Or if you want the loaded data to be recoverable :)
Also, you will find some nasty side affects when using
direct sql load (indexes are invalidated at the end
for rebuild). Of course you can use the
skip_unusable_indexes parameter to get around
concurrent query errors (this feature has been
And of course you shouldn't do this if you're running with a standby
database.
Jay Miller
-Original Message-
Sent: Wednesday, May 15, 2002 5:28 PM
To: Multiple recipients of list ORACLE-L
Command line option DIRECT=Y
Control file option UNRECOVERABLE
--- dist cash [EMAIL PROTECTED]
Command line option DIRECT=Y
Control file option UNRECOVERABLE
--- dist cash [EMAIL PROTECTED] wrote:
We have ORACLE 8.1.7.2 version running on SUn
Solaris. The ORACLE running
under archive log mode. everytime we use
Sql*loader to load data, it
will generate a lot of archive logs. Does
