Questions tagged [clob]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
23 views

Are LOBs also backed up if I take dump of all partitions of table individually?

I am taking export of a large table in oracle through datapump. I am taking export of all partitions one by one. The table has a LOB column as well. Are LOBs also backed up with partitions? Because ...
3
votes
1answer
251 views

How to migrate Unicode UTF-8 CLOB data from Oracle to SQL Server 2017 UTF-?

I am currently assisting in a migration effort of this application from Oracle 12c to SQL Server 2017. Initially I just performed table inserts using openquery to Oracle. I discovered that the tables ...
1
vote
1answer
61 views

Migrating 2+ GB Oracle CLOB column to SQL Server VARCHAR(MAX)

I have a column on an Oracle db containing HTML data with embedded images that result in some records being over 2GB in size for that column. I have successfully migrated the rest of the database to ...