My Oracle Support Banner

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

Last updated on APRIL 28, 2023

Applies to:

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


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
  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?


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

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