Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: BLOB move

RE: BLOB move

From: Fuad Arshad <fuadar_at_yahoo.com>
Date: Thu, 2 Sep 2004 10:41:53 -0700 (PDT)
Message-ID: <20040902174153.56748.qmail@web80506.mail.yahoo.com>


Mark,
this is 9.2.0.4
looking for an easier method.
We actually converting from long raw. adn we've seen the tables sizes go up big time. around 10-15G
Just looking for advice and experience as to how everyone sets it up the block size for the database is 8k  

"Mark W. Farnham" <mwf_at_rsiz.com> wrote:
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.



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org 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_at_freelists.org 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 - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe To read recent messages - http://freelists.org/archives/oracle-l/09-2004 Received on Thu Sep 02 2004 - 18:59:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US