Database Administration (MOSC)

MOSC Banner

ORA-1652: unable to extend temp segment by 128 in tablespace

edited May 17, 2010 8:42PM in Database Administration (MOSC) 5 commentsAnswered
This error occurs every morning at 2:15am.  In the error logs I see
May 16, 2010 2:00:00 AM CDT Clearing Resource Manager plan via parameter  May 16, 2010 2:18:38 AM CDT ORA-1652: unable to extend temp segment by 128 in tablespace TEMP  
My existing TEMP DDL is this.
CREATE SMALLFILE
    TEMPORARY TABLESPACE "TEMP" TEMPFILE
    'E:\ORACLE\ORADATA\SISI\TEMP01.DBF' SIZE 550M REUSE
    AUTOEXTEND
    ON NEXT  10240K MAXSIZE  550M EXTENT MANAGEMENT LOCAL UNIFORM
    SIZE 1024K;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMP"

I would like to increase the SIZE and MAXSIZE to 1024M.  What is the proper syntax?

Is it
ALTER TABLESPACE TEMP INCREASESIZE 1024M MAXSIZE 1024M;

Thanks for advice!

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