Re: Oracle Blob Issue

From: kirschk (kirsch.konstantin_at_swme.de)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 12:27:31 -0400

Hi there!
I have the same Problem here but at another context.
-----------
Did you find out if this problem can be solved somehow?
My situation is a little bit more complicated.

I have a table with a blob field.
In the blob field is a record of X kb.
Now I need to get rid of the X kb.
If I use null as value, then I loose the reference.
If I use empty blob, I dont gain free space, which is my goal.

How can I get rid of the blob data, without loosing the structure?

I am talking about 160 Gbyte blob Data, which must be dropped somehow…
and also quick,
so please answer as soon as possible,

Many many thanks,

kostas

Relevant Pages

  • Re: Problem retrieving images from Access 2003 Binary Large Object
    ... Eliminate the string functions ... >>>If I connect to the Access database from an ASP page and read the BLOB ... >>>returned when reading the BLOB field using MS Access, ...
    (microsoft.public.access.modulesdaovba)
  • Advice on using DISqlite3
    ... I'm trying the Personal edition of DISqlite3 and there ... What is the simplest way to store a stream in a blob field? ... bind the rowid to the prepared UPDATE statement ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Advice on using DISqlite3
    ... What is the simplest way to store a stream in a blob field? ... bind the rowid to the prepared UPDATE statement ...
    (borland.public.delphi.thirdpartytools.general)
  • RE: OCIDefineObject error
    ... Are you sure it's a BLOB? ... I notice you're fetching the payload from a queue table; ... DBD::Oracle::db prepare failed: ERROR OCIDefineObject call needed but not ... > I'm trying to retreive a blob field from oracle database. ...
    (perl.dbi.users)
  • CLOB to BLOB + charset conversion
    ... BLOB field. ... read in a part of the LONG column into varchar2 buffer ... I'd appreciate any pointers on what I can try next beacuse ...
    (comp.databases.oracle.misc)