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!

Partitioning a big table with a lob

Cyrille MODIANOJun 16 2016 — edited Jun 18 2016

Hi,

I have a table mainly used to store pdf documents.

The table will be partitioned by hash on an ID column to fit with the logic of the application.

I use a different tablespace for the table data, the table indexes and the table lob.

My concern is about the lob tablespace, it is a bigfile tablespace and can grow up to 32 TB, but that will not be sufficient, I will need to create at least 5 tablespaces for the lobs.

My question is : what is the best way to spread my lobs across multiple tablespaces?

Thanks

Cyrille MODIANO

This post has been answered by AndrewSayer on Jun 16 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 16 2016

Added on Jun 16 2016

#general-database-discussions

10 comments

675 views