Monday, September 26, 2016

SYSTEM TABLESPACE USAGE NOTES



  •  

    Users Default (SYSTEM)

    SYSTEM TABLESPACE USAGE NOTES:
  • Username - Name of the user
  • Created - User creation date
  • Profile - Name of resource profile assigned to the user
  • Default Tablespace - Default tablespace for data objects
  • Temporary Tablespace - Default tablespace for temporary objects
  • Only SYS, SYSTEM and possibly DBSNMP should have their default tablespace set to SYSTEM.

    select  USERNAME,
 CREATED,
 PROFILE,
 DEFAULT_TABLESPACE,
 TEMPORARY_TABLESPACE
from  dba_users
order  by USERNAME
    • By -
    Labels:

    No comments:

    Post a Comment

    Subscribe to: Post Comments (Atom)

    How To Fix Hive – Partition Table Query Failed When Stored As Parquet

    This article is about the bug in Hive filtering option, when the partition table query stored as parquet. Big data developers will help y...