This content has been marked as final. Show 4 replies
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..1 person found this helpful
Never Surrender Dreams!
If this question is answered, please mark the thread as closed and assign points where earned..
Apologies for delay, thx for input guys
i have same question ,,,i want to make insert script for table which contain blob column ..Please suggest me if any option is there