My Oracle Support Banner

Webcenter Content - Filestorage Table And Partitioning (Doc ID 1503697.1)

Last updated on OCTOBER 08, 2021

Applies to:

Oracle WebCenter Content - Version 10.0 and later
Information in this document applies to any platform.

Goal


To partition FILESTORE table in Webcenter Content 10g using a hash partition type like this:

create table ucm.filestorage_part
  PARTITION BY HASH(did, drenditionid) PARTITIONS 12
  TABLESPACE NEW_TBS
  as SELECT * FROM ucm.filestorage where 1 = 2;

Questions are:
1. Is it supported?
2. If it is supported, can they separate this table to other tablespace?
3. Are there any recommendations to partition FILESTORAGE table?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.