Re: How to use a RBS using SQL loader ?

On 12 Oct 1997, Tlcbus wrote:
>
> set transaction using rollback segment <RBS> allows a transaction to use a
> particular RBS.
> Question: How do you use this feature while using sql loader and export/import
> utililties ?

I don't know any way to specify a particular rollback segment in an import, but you can specify the COMMIT=Y argument. This causes commits at reasonably short intervals so that imports of large tables don't have to be done in a single large transaction.

A real problem is index creation in the import utility. They really need a way to specify unrecoverable and parallel clauses in the create index commands.

--
Jeremiah Wilton      http://www.wolfenet.com/~jeremiah