Friday, January 22, 2016

ORA-01652 unable to extend temp segment by 64 in tablespace TEMPORARY

ALTER TABLESPACE temporary ADD TEMPFILE 'E:\NBSD1314\TEMP02.ORA' SIZE 1000M AUTOEXTEND ON;
ALTER database TEMPFILE 'E:\NBSD1314\TEMP02.ORA' AUTOEXTEND ON NEXT 100M MAXSIZE unlimited;


change file location as per client DB folder

alter tablespace
   temporary
add tempfile
   'D:\APXD1516\TEMP02.ORA'
size
   1000m
autoextend on
next
   100m
maxsize
   unlimited;

No comments:

Post a Comment

Followers