Re: oracle error 1658

Failure to create the *initial* extent is almost always a sign that the tablespace involved is too small. Make it bigger by the three 'approved' methods:

1. Alter database datafile 'existing_datafile_path_&_filename' autoextend on'; (not recommended)
2. Alter database datafile 'existing_datafile_path_&_filename' resize Xm (make it bigger -that's OK)
3. Alter tablespace X add datafile 'newone' size Xm (add new datafile -recommended within reason)

Too many datafiles mean checkpoints take longer; too big datafiles mean backups and recoveries take longer. Strike a balance between 2 and 3. And opt for No.1 if you suffer from 'lazy DBA syndrome', and want Oracle to dig you out of holes (at the cost of performance).

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



<marima_at_my-deja.com> wrote in message news:8pm2qe$bjg$1_at_nnrp1.deja.com...


> i am importing tables and i get error 1658

> unable to create initial extent for segment in tablespace user_data

> how do i fix this

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.