ORA-1652: unable to extend temp segment by 128 in tablespace
This error occurs every morning at 2:15am. In the error logs I see
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!
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!
0