Re: Help pleasse..i get ORA-1658 error

The error message means that Oracle can't allocate enough space in the tablespace for your "partitions". Can you give more details on these partitions initial, minextents, ...). Also, the error should be described in more details in the alert log, did you check it out?

Daniel

avsrk_at_mailcity.com (Subrahmanyam Arya) wrote in message news:<25c1993e.0305070703.21950115_at_posting.google.com>...
> Dear oracle gurus,
>
> I donot have DBA knowledge and i need help on this ORA-1658 error
>
> 1] I created a tablespace by name STATS as below
>
> CREATE TABLESPACE STATS DATAFILE
> '/opt/PlexView/Oracle/ora02/plxdb/stats/stats.dbf' SIZE 104M REUSE
> AUTOEXTEND ON NEXT 1280K MINIMUM EXTENT 128K DEFAULT STORAGE (INITIAL
> 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0 )
>
> Essentialy i copied the definition that DBASSIST would use to create
> USERS tablespace. I saved that script ( plxdbrun1.sh script)
>
> Now I get the following error when i try to add partitions from my
> application
>
> SQLException on add partition:
> ORA-01658: unable to create INITIAL extent for segment in tablespace
> STATS
>
> I donno why i see this error. I did not see this previously
>
> I also queried DBA_FREE_SPACE and i get for BYTES field as 122880
>
> How do i solve this ??? Also, the Solaris system on which my database
> is running is having ample disk space. Infact
> '/opt/PlexView/Oracle/ora02/plxdb/stats/stats.dbf' has been on a
> separate mount point of 40 Gig drive space.
>
> Will altering the definition of the tablespace by using the Local
> option to extent_management clause help (ORACLE 8i DBA handbook page
> 588..) so that tablespace will manage its own space..
>
> -Your help is greatly appreciated,
>
> thanks,
> avsrk
Received on Thu May 08 2003 - 16:22:58 CEST