Home » SQL & PL/SQL » SQL & PL/SQL » BLOB records deletion (Oracle 9i2)
BLOB records deletion [message #422748] Fri, 18 September 2009 11:16 Go to next message
sandman42
Messages: 14
Registered: June 2007
Junior Member
Hi,

I have a table that's made of an integer and a blob.

When I delete some rows, I have an error, ORA-01654, saying it can not extend a SYS_IL47389340 index in the tablespace.

The error makes sense, since the tablespace is almost full, but my questions are:

1) How deletion works in this case? Usually, AFAIK deleted records are put in rollback segments or undo. For BLOB type what happens? It makes me wonder this kind of error: why does it want to extend an index during deletion?

2) Since the tablespace is almost full, is there any way to circumvent the problem, other than adding a new datafile?

Thanks a lot

Re: BLOB records deletion [message #422750 is a reply to message #422748] Fri, 18 September 2009 12:10 Go to previous message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) LOB works differently, undo is stored in the same segment than BLOB itself, see PCTVERSION and RETENTION parameters.

2) truncate the table? Wink
Change PCTVERSION and RETENTION parameters for your BLOB

Regards
Michel

Previous Topic: Error PLS-00103
Next Topic: How to convert simple SQL into Stored Procedures?
Goto Forum:
  


Current Time: Wed Sep 28 09:14:48 CDT 2016

Total time taken to generate the page: 0.19056 seconds