| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP! Disabling Rollback Segments
A copy of this was sent to "Mark Kimball" <mkimball_at_rhs.org>
(if that email address didn't require changing)
On Tue, 06 Apr 1999 18:54:09 GMT, you wrote:
>We are currently building a data warehouse and have had problems with
>loading data due to the rollback segments. We keep getting errors that the
>rollback segments need to be extended when it appears they are big enough.
>We have 2 rollback segments at 300M each. Is it possible to take the
>rollback segments offline when loading and bring them back online after the
>load it complete? Thank you for any help you can provide.
>
How are you loading the data? Can you use the direct=true mode of the sqlldr tool? If so, you can in fact bypass both redo and undo (if the database is in noarchivelog mode).
Can you give us more info about exactly how you are loading the data?
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |