Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-1653: unable to extend table - Why?

RE: ORA-1653: unable to extend table - Why?

From: Miller, Jay <JayMiller_at_TDWaterhouse.com>
Date: Tue, 03 Dec 2002 07:18:47 -0800
Message-ID: <F001.00510C6E.20021203071847@fatcity.com>


Ron,

Good idea, but DEGREE=1

There are two indexes, but they are in a different tablespace (which has plenty of free space available and did not give an error).

Next extent size is 25M but, as mentioned, it shouldn't have needed a new extent.

I'm still at a loss...

Jay

-----Original Message-----
Sent: Monday, December 02, 2002 6:14 PM
To: Multiple recipients of list ORACLE-L

One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table?
What is the next extent size set to?
If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by
this a few times...)
How many indexes and are they in the same tablespace?

Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com
Each new user of a new system uncovers a new class of bugs. -- Kernighan  

                      JayMiller_at_TDWater

                      house.com                To:
ORACLE-L_at_fatcity.com
                      Sent by:                 cc:

                      root_at_fatcity.com         Subject:  RE: ORA-1653:
unable to extend table - Why?    
                      12/02/2002 02:04

                      PM

                      Please respond to

                      ORACLE-L

 

 





Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists.

Jay

-----Original Message-----
Sent: Friday, November 29, 2002 8:54 PM
To: Multiple recipients of list ORACLE-L

Richard,

if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert.

As for meeting in person.... there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita Bardeen, also of this list. They are all presenting :)

I saw Priscilla about a month ago, haven't talked with her since.

Rachel


Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Miller, Jay
  INET: JayMiller_at_TDWaterhouse.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron Thomas
  INET: rthomas_at_hypercom.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: JayMiller_at_TDWaterhouse.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Dec 03 2002 - 09:18:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US