Oracle_BlobClob

Steps to Attach “10M.zip” file to Oracle Table
1. Save “10M.zip” file at DUMP_DIR
2. Attach
3. Check if Attach successfully

create or replace directory DUMP_DIR as ‘/net/xxx/scratch/xxx’;

declare
   l_bfile bfile;
   l_blob blob;
 begin
   update TABELExxx set Col_Bobxxx = empty_blob() where ROWIDxxx=1000
   return Col_Bobxxx into l_blob;
   l_bfile:=bfilename('DUMP_DIR','10MB.zip');
   dbms_lob.open(l_bfile,dbms_lob.file_readonly);
   dbms_lob.loadfromfile(l_blob,l_bfile,dbms_lob.getlength(l_bfile));
   dbms_lob.close(l_bfile);
   commit;
 end;
/


select ROWIDxxx,Col_Bobxxx,dbms_lob.getlength(Col_Bobxxx) from TABELExxx order by dbms_lob.getlength(Col_Bobxxx)  desc;