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

There is apparently insufficient free space on opt/PlexView/Oracle/ora02/oradata/testdb/ to allocate any more extents - either from a lack of actual space or because you already have 4096 extents allocated. If the latter set the maxextents to unlimited...

avsrk_at_mailcity.com (Subrahmanyam Arya) wrote:

>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

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Thu May 08 2003 - 21:45:54 CEST