AD_MONITOR Schema with default SYSTEM Tablespace (Doc ID 353741.1)

Last updated on DECEMBER 06, 2024

Applies to:

Goal

Running a check about non-system Schemas using the SYSTEM Tablespace as default, shows that a User AD_MONITOR was defined using the SYSTEM Tablespace as Default Tablespace.

This additional Schema was introduced via the <Patch 3258830> - 'Patch 11i.OAM.H'.

1. Check your environment using following select :

 On a internal Instance it shows following :

USERNAME   DEFAULT_TBSP      TEMPORARY_TBSP          ACCOUNT_STATUS              CREATED
----------           ------------                --------------           -----------------            ---------
AD_MONITOR    SYSTEM                   SYSTEM                 EXPIRED & LOCKED           20-JAN-06

Can the default Tablespace be changed to another Tablespace than the SYSTEM Tablespace ?

Solution

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