Hi Sir, I want move “Blob data” from one Database to Another Database
How to process on this? Thank you..
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
You can use an insert statement with a DB link created for the remote database. For example:
In this case, I am assuming the DB link remote_db is created at the source database so that you will execute the above statement from the source database.
If the DB link is created at the target database, then below is an example of executing the statement from target/remote database:
This is as simple.
Please let me know if you are facing some specific issues.
Sure,
Thank you Sir..
You can also try this way i read on a Blog by philipp hartenfeller 🙂
for me it works really fine 😉
https://hartenfeller.dev/blog/oracle-dml-script-images-blob-values