Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Faster imports
Isn't it true that if you specify 'unrecoverable', you shouldn't have to disable
archiving?
rob van laarhoven wrote:
> This is what I can think of. Maybe one of the suggestions can be used in
> your shop.
>
> - Disable archiving, but you'll have to make a backup immediatly after
> enabling archiving.
> - Place dmp file on a different disk than redo-logs, rollback segment, data
> tablespaces; reducing IO contention.
> - Create character-separated file and use direct sqlload, this is faster
> than export.
> - start database with a init.ora designed to speed up an import
> - Use a lot of (5?) big redo logs(10Mb?).
>
> One of the reasons why the unrecoverable option is so much faster is that
> it's bypassing the rollback segments. This can not be done using import. The
> dml done with the unrecoverable option is lost after a database recovery.
>
> Regards,
> Rob.
>
> Rob.
Received on Wed Jan 19 2000 - 13:58:22 CST
![]() |
![]() |