> -----Original Message-----
> From: Peter R [mailto:[EMAIL PROTECTED]]
>
> How can I turn off logging for a table in Oracle7.3 database.
Recoverable/unrecoverable is not a "persistent" attribute in 7.3.4 The "unrecoverable" option only applies to the create table but not to any subsequent operations.
But starting with Oracle 8.0, the "nologging" option (which replaces the deprecated "unrecoverable") on a create table will also apply to subsequent operations like Direct SQL*Loader and direct-load inserts. If you don't specify logging/nologging at table creation time then, as expected, the setting will be taken from the tablespace defaults.
