I have managed to upload my word and pdf documents into the database using blob support in APEX and having these columns in MY_DOC table
,FILENAME VARCHAR2(400) NOT NULL
Now I would like to migrate the data to another environment using a SQL insert script, how do I cater for the BLOB column in the insert script?
you can not migrate blob data with insert scripts. You can however achieve this by using the datapump...
expdp sysadm/sysadm tables=<table_name> dumpfile=dump.dmp logfile=expdp_dump.log schemas=<your_schema>
impdp sysadm/sysadm dumpfile=dump.dmp
Can also use a select insert construct to migrate data with blob/clobs..
Never Surrender Dreams!
If this question is answered, please mark the thread as closed and assign points where earned..