Re: Newbie DBA Question: ORA-01658

Make the tablespace bigger by one of the usual 3 methods:

1. Add a new data file (alter tablespace X add datafile 'path/filename' size 300M;)
2. Make one of the existing files start auto extending (alter database datafile 'path/filename' autoextend on next 20m maxsize 900M;)
3. Manually resize one of the existing datafiles (alter database datafile 'path/filename' resize 900m;)

Your error message means that you've run out of space, so when trying to create the new index segment, there isn't enough room for that segment's initial extent.

Regards
HJR

--

Oracle Resources : http://www.geocities.com/howardjr2000
========================================


"Jerry Li" <jerryli60540_at_yahoo.com> wrote in message
news:cb3bafcf.0110300840.2e30c48d_at_posting.google.com...


> ORA-01658: unable to create INITIAL extent for segment in tablespace

> TASDEVT_INDEXES_VOD

>

> What do I need to do?

>

> Thanks,

>

> Jerry