My Oracle Support Banner

User temporary tablespace is not used when dbms_stats run as same user (Doc ID 1908494.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


 Temporary tablespace assigned to user(example:scott) will not be used when sys owned packages like dbms_stats are executed as user(scott)

 TEMP_SCOTT is the temp tablespace assigned to scott and temp_sys is the default temp tablespace for the database .

  While running the dbms_stats as scott user you may receive

ORA-01652: unable to extend temp segment by 1280 in tablespace TEMP_SYS   <<<<<< TEMP_SYS while we are connected with SCOTT
ORA-06512: at "SYS.DB_STATS_EXT", line 4
ORA-06512: at "SCOTT.DB_STATS_INT", line 3
ORA-06512: at line 1




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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