RE: BLOB move

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Wed, 01 Sep 2004 19:18:56 -0700
Message-Id: <1094091536.6139.203534804@webmail.messagingengine.com>

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_at_rsiz.com> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Fuad Arshad
> Sent: Wednesday, September 01, 2004 12:15 PM
> To: oracle-l_at_freelists.org
> 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.
>
>

---

To unsubscribe send an email to: oracle-l-request_at_freelists.org and put 'unsubscribe' in the subject line.

Recent messages - http://freelists.org/archives/oracle-l/09-2004 Received on Thu Sep 02 2004 - 02:59:02 CDT