Database DataWarehousing (MOSC)

MOSC Banner

Separate tablespace for LOBs ?

edited Mar 13, 2018 10:21AM in Database DataWarehousing (MOSC) 6 commentsAnswered ✓

Our database is 12.1.0.2

And we have a huge partitioned  table with one of the columns as SecureFile LOB which is also partitioned

What are the pros and cons of putting the LOB column data and indexes into a separate tablespace?

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