Help pleasse..i get ORA-1658 error
Date: 7 May 2003 08:03:27 -0700
Message-ID: <25c1993e.0305070703.21950115_at_posting.google.com>
I donot have DBA knowledge and i need help on this ORA-1658 error
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