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
-----------------------------------------------------------------
