Re: slow imports

The tables already exist. What about their indexes ? If they exist, drop them (except the primary keys) and re-create them after the import (with good storage clause). Rollback segments on the same disks that data segments ? How many rows per tables do you import ?

During the import you can do a 'ALTER TABLESPACE your_ts COALESCE' on your rollback segment tablespace.

Set buffer parameter to the largest row you're inserting.

Import of RAW/LONG RAW are slow.

Lisa Lewis wrote:

> 
> Same old problem .... slow imports
> 

	*****************************************


	* Jean-François LEGUILLIER              *

	*                                       *

	* PARTNER SYSTEM                        *

	* 2-4 Bd des Iles                       *

	* Le Seine Saint Germain                *

	* 92130 Issy les Moulineaux             *

	*                                       *

	* Tél : 01.41.46.09.00                  *

	* Fax : 01.41.46.09.09                  *

	* email : leguillier_at_partner-system.com *

	*                                       *

	* web : http://www.partner-system.com   *


	*****************************************