Moving LOBs and archivelog creation
I am trying to tidy up a database where many lobsegments have been created in normal 8KB tablespaces.
Most of these lobsegments are not very big (less than 1GB). But a few are very large and one, in particular, has 469GB).
I've made some tests moving medium-sized lobsegments and it looks as though the move creates about 2x the size of the data in archivelogs.
I can move the medium sized ones (up to about 150GB) over time, but moving a single 469GB one would be problematic.
I haven't found anything about this in the documentation, so I ask for your help: do I really have to create so much archivelog and is there a better way to move the data?