Hello,
I am using expdp/impdp to export one table containing blobs from a production database to a development database. The log files show no errors but the blob data is being imported into the document_text column instead of the content column
Database: 11g Enterprise Edition Release 11.2.0.3.0 -- 64 bit
Export: Release 11.2.0.3.0
Import: Release 11.2.0.3.0
OS: Linux 2.6.32-573.12.1.e16.x86_64
Structure of table being exported/imported:
Create table documents(
id number
,name varchar2(400)
,mime_type varchar2(48)
,doc_size number
,dad_charset varchar2(128)
,last_updated date
,content_type varchar2(128)
,content blob
,app_name varchar2(30)
,document_text clob
,app_id varchar2(50));
The column in question is the CONTENT column.
Par File documents.par
userid=myuser/mypwd@mysid
dumpfile=prod_documents.dmp
directory=PROD_DEV_SYNC
reuse_dumpfiles=y
exclude=statistics,grants,triggers,constraints
tables=documents
query=documents:"Where last_updated > sysdate-30"
Export Command on the Production server
expdp parfile=documents.par
402 rows were exported with the size of 554.5 MB
Import Command
impdp myuser/mypwd@mysid directory=PROD_DEV_SYNC dumpfile=PROD_documents.dmp logfile=dev_documents.log table_exists_action=append content=data_only
Results
The export and import were both successful. There we no errors in the log file or the alert log file.
Once the import is done, there is no data in the content column. It's been put in the document_text column and is unreadable. The data is usually .msg files and .pdf files.
The data for a sample record is:
id: 1
name: my_msg.msg
mime_type: application/vnd.ms-outlook
doc_size: 1234
dad_charset: Null
last_updated: 09-MAY-18 8:49:18 AM
content_type BLOB
content blob: Null
app_name: my_app
document_text: garbled characters that look like Chinese and English. No translations were expected.
app_id:2
Any insight on why this is occurring would be helpful. Otherwise, I will go back to the old exp/imp as that does work.
Thanks,
Becky