Toad World® Forums

Best way to export a BLOB


#1

I have the table who’s script is below.

Do you have a recommendation for exporting the BLOB.

If you look at the screen shot you will see the keys alonmg with the name of the file that is in the BLOB.

Any suggestions?

CREATE TABLE MRRDBO.MRR_NOTES_ATTACH

(

I_NOTES NUMBER NOT NULL,

I_ATTACH NUMBER NOT NULL,

T_ATTACH BLOB,

N_FILE VARCHAR2(255 BYTE),

N_DIR VARCHAR2(255 BYTE),

N_CREAT_BY VARCHAR2(30 BYTE) DEFAULT user,

D_CREAT DATE DEFAULT sysdate,

N_ORA_DB_USER VARCHAR2(30 BYTE) DEFAULT user NOT NULL,

S_ROW_UPD DATE DEFAULT sysdate NOT NULL,

C_ATTACH_TYPE VARCHAR2(256 BYTE),

N_ATTACH_DESC VARCHAR2(256 BYTE)

)

LOB (T_ATTACH) STORE AS (

TABLESPACE MRR_T03_L_200K

ENABLE STORAGE IN ROW

CHUNK 8192

PCTVERSION 10

NOCACHE

LOGGING

  STORAGE    (

              INITIAL          200K

              NEXT             200K

              MINEXTENTS       1

              MAXEXTENTS       UNLIMITED

              PCTINCREASE      0

              BUFFER_POOL      DEFAULT

             ))

TABLESPACE MRR_T03_L_200K

PCTUSED 0

PCTFREE 10

INITRANS 1

MAXTRANS 255

STORAGE (

        INITIAL          200K

        NEXT             200K

        MINEXTENTS       1

        MAXEXTENTS       UNLIMITED

        PCTINCREASE      0

        BUFFER_POOL      DEFAULT

       )

LOGGING

NOCOMPRESS

NOCACHE

NOPARALLEL

MONITORING;

COMMENT ON TABLE MRRDBO.MRR_NOTES_ATTACH IS ‘Notes Attachment’;

COMMENT ON COLUMN MRRDBO.MRR_NOTES_ATTACH.I_NOTES IS ‘NotesId’;

COMMENT ON COLUMN MRRDBO.MRR_NOTES_ATTACH.I_ATTACH IS ‘Attachment Id’;

COMMENT ON COLUMN MRRDBO.MRR_NOTES_ATTACH.T_ATTACH IS ‘Attachment’;

COMMENT ON COLUMN MRRDBO.MRR_NOTES_ATTACH.N_FILE IS ‘FileName’;

COMMENT ON COLUMN MRRDBO.MRR_NOTES_ATTACH.N_DIR IS ‘DirecroryName’;

COMMENT ON COLUMN MRRDBO.MRR_NOTES_ATTACH.N_CREAT_BY IS ‘CreatedBy’;

COMMENT ON COLUMN MRRDBO.MRR_NOTES_ATTACH.D_CREAT IS ‘CreatedOn’;

COMMENT ON COLUMN MRRDBO.MRR_NOTES_ATTACH.N_ORA_DB_USER IS ‘LastUpdatedBy’;

COMMENT ON COLUMN MRRDBO.MRR_NOTES_ATTACH.S_ROW_UPD IS ‘LastUpdatedTimeStamp’;

CREATE UNIQUE INDEX MRRDBO.PK_MRR_NOTES_ATTACH ON MRRDBO.MRR_NOTES_ATTACH

(I_NOTES, I_ATTACH)

LOGGING

TABLESPACE MRR_T03_L_200K

PCTFREE 10

INITRANS 2

MAXTRANS 255

STORAGE (

        INITIAL          200K

        NEXT             200K

        MINEXTENTS       1

        MAXEXTENTS       UNLIMITED

        PCTINCREASE      0

        BUFFER_POOL      DEFAULT

       )

NOPARALLEL;

CREATE OR REPLACE PUBLIC SYNONYM MRR_NOTES_ATTACH FOR MRRDBO.MRR_NOTES_ATTACH;

ALTER TABLE MRRDBO.MRR_NOTES_ATTACH ADD (

CONSTRAINT PK_MRR_NOTES_ATTACH

PRIMARY KEY

(I_NOTES, I_ATTACH)

USING INDEX MRRDBO.PK_MRR_NOTES_ATTACH

ENABLE NOVALIDATE);
screenshot.jpeg


#2

Do you have a recommendation for exporting the BLOB.

Do you mean only BLOB columns or the whole table with BLOBs?

If only BLOB column, is it one record or many of them?

One column, double click and then save the content to a file with proper extension.