Home -> Usenet -> comp.databases.oracle -> Help pleasse..i get ORA-1658 error

Help pleasse..i get ORA-1658 error

From: Subrahmanyam Arya <avsrk_at_mailcity.com>
Date: 7 May 2003 08:03:27 -0700
Message-ID: <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 Wed May 07 2003 - 17:03:27 CEST












Original text of this message