Database Administration (MOSC)

MOSC Banner

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center