| No redo logs [message #53223] |
Wed, 04 September 2002 14:22  |
David Reid
Messages: 1
Registered: September 2002
|
Junior Member |
|
|
I have an Oracle 8i database that is always in Archive Log Mode and uses two primary tablespaces, let's call them A and B.
It is necessary that tablespace A generate redo logs, (for backup purposes) but I do not want tablespace B to generate redo logs. How can I do this?
I've tried using Oracle DBA Studio to select "No" under the Enable Logging option for tablespace B, but this doesn't work.
Thanks,
Dave
|
|
|
|
| Re: No redo logs [message #54364 is a reply to message #53223] |
Wed, 13 November 2002 11:45  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Dave,
You can disable the redo logs generation with NOLOGGING option on tables and indexes, but even then not all SQL statements will obey this rule. The fact is that Oracle always generates redo logs for certain operations.
I found two reference sources which describe in depth the LOGGING/NOLOGGING process. The links are Here and Here
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
