RE: BLOB move

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 http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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 http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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 - http://freelists.org/archives/oracle-l/09-2004

Other related posts: