Thank you very much. I've exported 150 grams of CSV files containing blob data, but I'm frustrated that I can't import new DB with a lot of tools.Because they both thought the CSV format was incorrect.Do you have a way to import these CSV files?
CREATE TABLE ATTACHMENT
(
JOB_FILE_ID integer NOT NULL,
LINE_NO integer NOT NULL,
FILE_NAME LONG_TEXT,
FILE_SIZE decimal(10,0),
ATTACHMENT BINARY_DATA
);
GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
ON ATTACHMENT TO SYSDBA WITH GRANT OPTION;
zaher
commented
7 years ago
Thank you very much. I've exported 150 grams of CSV files containing blob data, but I'm frustrated that I can't import new DB with a lot of tools.Because they both thought the CSV format was incorrect.Do you have a way to import these CSV files?
CREATE TABLE ATTACHMENT ( JOB_FILE_ID integer NOT NULL, LINE_NO integer NOT NULL, FILE_NAME LONG_TEXT, FILE_SIZE decimal(10,0), ATTACHMENT BINARY_DATA );
GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE ON ATTACHMENT TO SYSDBA WITH GRANT OPTION;
the test.csv down https://www.dropbox.com/s/sv2elc4s7vlhbq0/test.csv?dl=0