Go to the FreeLists Home Page Home Signup Help Login
 



Browse oracle-l: This Month's ArchiveMain Archive PageRelated postsPrevious by DateNext by Date

BLOB move

  • From: Fuad Arshad <fuadar@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 1 Sep 2004 09:15:24 -0700 (PDT)
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
-----------------------------------------------------------------

Other related posts:

  • BLOB move
  • RE: BLOB move
  • RE: BLOB move
  • RE: BLOB move
  • RE: BLOB move
  • RE: BLOB move




  • [ Home | Signup | Help | Login | Archives | Lists ]

    All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
    Everything else ©2008 Avenir Technologies, LLC.