The blob tag has no wiki summary.
1
vote
0answers
16 views
BLOB storage in rows
I have a database that has several BLOB columns scattered across multiple tables. Since I am a developer and am looking at making application code writing easier, I wanted to turn these columns into ...
1
vote
0answers
241 views
How can one reliably update a LOB column with data from another LOB column in Oracle?
I have tried:
UPDATE "SCHEMA".TABLE SET LOB_COLUMN = (SELECT LOB_COLUMN FROM "SCHEMA".TABLE)
I have tried:
CREATE OR REPLACE PROCEDURE COPY_LOB_DATA IS
OLD_BLOB BLOB;
NEW_BLOB BLOB;
...
1
vote
0answers
232 views
DBMS_LOB.READ performance and Oracle BLOB chunk size
I have a script that reads a lot of BLOBs using DBMS_LOB.READ, in the process of converting them to files. While looking to improve the read speed, I looked at GETCHUNKSIZE.
The documentation on ...
0
votes
0answers
65 views
Copying BLOB fields from a table on one server into corresponding fields in a corresponding table on a different server?
I have a database on a remote server whose BLOB fields are corrupted. I have fields in an earlier copy of the database which duplicate a portion of the corrupted data. I would like to overwrite the ...
