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

Hi,

More details from alert_<mysid>.log in
<...>/admin/<mysid>/bdump/alert_<mysid>.log

My tablespace details
TABLESPACE_NAME = STATS
DATFILE '/opt/PlexView/Oracle/ora02/oradata/testdb/stats.dbf' SIZE 104M REUSE AUTOEXTEND ON NEXT 1280K MINIMUM EXTENT 128K
INITIAL EXTENT 128K
NEXT 128K
MINEXTENTS 1
MAXEXTENTS 4096
PCTINCREASE 0 My table is defined to use the above tablepsace and so i guess my partitions will be using the above storage parameters

I see the following errors in the alert log ORA-3233: unable to extend table <SCHEMA>.PEGCOUNT20 subpartition SYS_SUBP691 by 16 in tablespace STATS
and many more ORA-3233 errors

ORA-3234: unable to extend index <SCHEMA>,PEGCOUNT_INDEX20 subpartition SYS_SUBP708 by 16 in tablespace STATS

However, i dont see ORA-1658 in the alert log. I see in my application log as my application is ctaching and printing java.sql.SQLException as ORA-01658: unable to create INITIAL extent for segment in tablespace STATS

Q? Let me know if i have to furnish any more information

Q? How and which dictionary should i query to know that there is not enough freespace for my table space

Q? After i did ALTER TABLESPACE STATS ADD DATAFILE ( i used the same original parameters) things seem to work fine...

Q? How do i adjust the initial defaults. Is it because the MAXSIZE is not set to UNLIMITED that i see this error ???

Q? Why do i need to add additional dbf files when the AUTOEXTEND clause is ON ???

-thx,
avsrk

danielroy10_at_hotmail.com (Daniel Roy) wrote in message news:<1b061893.0305080622.1025a7d5_at_posting.google.com>...
> 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 - 20:00:01 CEST