Re: oracle error 1658

Hello,

Why opt No.1 would mean a lost of performance in comparison with opt No.2 ?

Thank in advance,

Erika

"Howard J. Rogers" wrote:
>
> 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.
Received on Thu Sep 21 2000 - 00:00:00 CDT