Mark Try this alter table pcst_txn move tablespace users LOB(content) store as(tablespace users disable storage in row); In addition chek the following links should help http://64.233.167.104/search?q=cache:cejRAdfFIiQJ:forums.dbasupport.com/oracle/ora9i/transitioning.shtml+Move+BLOBs+from+one+tablespace+to+another&hl=en&lr=lang_en http://64.233.167.104/search?q=cache:821qqOtr-YEJ:www.experts-exchange.com/Databases/Oracle/Q_20272703.html+Move+BLOBs+from+one+tablespace+to+another&hl=en&lr=lang_en HTH GovindanK On Wed, 1 Sep 2004 15:23:18 -0400, "Mark W. Farnham" <mwf@xxxxxxxx> said: > There are major changes in the ways blobs are stored across certain > version > boundaries, and in fact some pretty neat early storage management > featured > were deprecated because it was possible to really screw things up (it was > also possible to make things really sweet). > > So -- what are you running? Definitely take a look at the options for > your > release. > > mwf > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Fuad Arshad > Sent: Wednesday, September 01, 2004 12:15 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: BLOB move > > > We're in the process a data conversion from long to blob. > since this is an existing table. > I was wondering is there any way to move the blob segment & blob index > segment to another tablespace without rebuilding the table. > Also we've noticed that blob is takign up much more space than the long > . > is that normal. > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- ---------------------------------------------------------------- To unsubscribe send an email to: oracle-l-request@xxxxxxxxxxxxx and put 'unsubscribe' in the subject line. Recent messages - //freelists.org/archives/oracle-l/09-2004