DBA best practice: Avoid creating objects in the SYSTEM tablespace

book

Article ID: 160641

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

Creating Objects in the System tablespace.

Resolution

It has long been a DBA best practice to avoid creating objects in the SYSTEM tablespace.  SYSTEM tablespace is for Oracle system objects only.  Unfortunately, if an Oracle user account is created without specifying the default tablespace, any objects created will appear in SYSTEM.

The best practice is to associate each user account with a default tablespace.

See Also:  TECH221780:  Does Symantec DLP create objects in the SYSTEM tablespace?