Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

datapump 19.24 into 19.28 via dblink

tmbeetzSep 26 2025

Hello,

a table with 37Mio rows and a small clob column. The clobs wirh an anverage size of 547 bytes. Therefore the clobs are stored in the table and not in the LOB Segment. The datapump process will take many hours, for only 150GB. The datapump in a dumpfile will take also many hours. Have anybody a good idea. The plan is transfer the schema and this table without data. In a second step transfer data via dblink direct in the new database.

Regards Thomas

This post has been answered by VOEURNG SOVANN on Jan 13 2026
Jump to Answer
Comments
Post Details
Added on Sep 26 2025
2 comments
177 views