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

tmbeetz2 days ago

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

Comments
Post Details
Added 2 days ago
0 comments
19 views