Where does the content services stores its data in Metadata Repository?

The Content Services data is stored by default in the schema CONTENT, with two other schemas whose names are derived from this, CONTENT$CM and CONTENT$ID, that are used for integration purposes.

It is possible to use just the one database for all these purposes, but such an arrangement would only be suitable for a relatively small-scale installation. In most circumstances, the schema will be in a database created specially for this purpose and tuned accordingly.

If a single database instance can’t provide adequate response times, RAC can take the scalability to whatever is required. It is however not possible to spread one domain’s data across multiple databases.

There are several tablespaces used for storing Content Services data:

1. CONTENT_IFS_MAIN: This stores the tables that hold metadata-describing documents
   
2. CONTENT_IFS_LOB_N: This stores the BLOB (binary large object) columns that hold the actual documents for non-indexed documents.
   
3. CONTENT_IFS_LOB_I: This stores the BLOB columns that hold the actual documents for indexed documents.
   
4. CONTENT_IFS_CTX_I, CONTENT_IFS_CTX_K, CONTENT_IFS_CTX_X: These tablespaces store the indexing data used by Search