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);