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

Last updated on APRIL 28, 2023

Applies to:

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

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