| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-1653: unable to extend table - Resolved?
Well, I reduced the PCTUSED and PCTFREE on Friday and a small insert (app.
30,000 rows) seems to have worked as expected. No additional space was
claimed and NUM_FREELIST_BLOCKS declined. I'll wait and see what happens
during our next large insert.
But for now it seems like changing these parameters may have resolved the problem.
Jay Miller (with fingers crossed)
-----Original Message-----
Sent: Friday, December 06, 2002 4:19 PM
To: Multiple recipients of list ORACLE-L
How badly do you want the space back? I believe you will indeed need to touch each row.
You could update each row with something like (update .... set column-1=column-1)
Good luck!
Barb
"Miller, Jay" <JayMiller_at_TDWaterhouse.com> wrote:
But will this solve my problem in the near term? My understanding is that simply changing the PCT USED won't move the problematic blocks off the freelist until some sort of DML touches the block. Am I correct in this and if so is there any way to resolve it?
Jay
Do you Yahoo!?
Yahoo! Mail <http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com>
Plus - Powerful. Affordable. Sign up
<http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com> now
--
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 Mon Dec 09 2002 - 16:19:30 CST
 |
 |