Primavera (MOSC)

MOSC Banner

What data is stored in the different table spaces in Oracle DB?

edited Nov 24, 2016 6:06AM in Primavera (MOSC) 4 commentsAnswered

Hello,

We are bumping up against table space limits. We are trying to understand what data is stored in which table spaces in an Oracle DB.

  • P6 16.1
  • Oracle 11gR2

Table Spaces are:

  • PMDB_DAT1
  • PMDB_LOB1
  • PMDB_NDX1
  • PMDB_PX_DAT1

My assumptions are the extended table data for BI Publisher reporting is in the PX_DAT1 table space. And the Indexes are in the NDX1 tablespace. And the project data is in the DAT1 tablespace. What does in the LOB1 tablespace?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center