Oracle Text (MOSC)

MOSC Banner

index partition and lob partition required?

edited Apr 12, 2016 5:22AM in Oracle Text (MOSC) 1 commentAnswered ✓

After upgrade OCBRM from 7.3.1 to 7.5(DB11g), it is found that many SYS_IL0000 (INDEX PARTITION) and SYS_LOB0000 (LOB PARTITION) had been created as below.

OWNER      OBJECT_NAME                              OBJECT_TYPE         CREATED              STATUS    COUNT(1)

---------- ---------------------------------------- ------------------- -------------------- ------- ----------

PIN        SYS_IL0000819177C00084$$                 INDEX               23-FEB-2016 02:34:44 VALID            1

PIN        SYS_IL0000819177C00084$$                 INDEX PARTITION     23-FEB-2016 02:34:44 VALID           77

PIN        SYS_LOB0000819177C00084$$                LOB                 23-FEB-2016 02:34:44 VALID            1

PIN        SYS_LOB0000819177C00084$$                LOB PARTITION       23-FEB-2016 02:34:44 VALID           77

They are mapped into different partitioned tablespace. We will create new partitioned tablespace manually per month.

This month, after creating the new tablespace PIN61, there is no mentioned index partition and lob partition as above.

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