Oracle DB: Seperate LOB Column to a sperate tablespace

[bingluo]

It is a best practice for the Oracle DB to have seperate for LOBs for performance and maintaince:

https://docs.oracle.com/cd/B28359_01/appdev.111/b28393/adlob_tables.htm#i1006434

"

Best performance for LOBs can be achieved by specifying storage for LOBs in a tablespace different from the one used for the table that contains the LOB. If many different LOBs will be accessed frequently, then it may also be useful to specify a separate tablespace for each LOB column or attribute in order to reduce device contention.

"

I suggest we offer "how to do this" documentation and DB scripts for Seperate LOB Column to a sperate tablespace in Oracle DB.

[guanyun_yuan]

Pls add this feature,thank you.

[daniel_crisan]

I will move this idea to "declined" as from what I understand from the above statement this procedure is not specifically related to the OO product.