Skip to Main Content
  • Questions
  • Copy data with BLOB using @dblink to my Staging database


Question and Answer

Connor McDonald

Thanks for the question, Jose.

Asked: September 20, 2021 - 11:27 am UTC

Last updated: September 23, 2021 - 7:45 am UTC

Version: 11

Viewed 100+ times

You Asked

Hi :)!

I have a database @dblink and I need to copy files with BLOB from @dblink to my staging database.

What can I do?
I can't CREATE tables because of restrictions, so we only should use TRUNCATE, UPDATE and INSERT.

Thank you so much in advance!

and we said...

More to Explore


Need more information on Administration? Check out the Administrators guide for the Oracle Database