✍ Kashif M
Trends

Tuesday, 16 July 2013


Increase temporary tablespace size in oracle


By on July 16, 2013


If you want to know the location of temporary tablespace:

SELECT tablespace_name, file_name, bytes
FROM dba_temp_files WHERE tablespace_name = 'TEMP';

If you want to delete the temporary tablespace:

ALTER DATABASE 
TEMPFILE 'C:\APP\BI\ORADATA\ORCL\TEMP01.DBF' 
DROP INCLUDING DATAFILES;


Recreate your tablespace with maxsize:

ALTER TABLESPACE temp ADD TEMPFILE
'C:\APP\BI\ORADATA\ORCL\TEMP01.DBF' SIZE 512m
AUTOEXTEND ON NEXT 250m MAXSIZE UNLIMITED;




Kashif
mkashu: Increase temporary tablespace size in oracle
Review : Kashif | Kashif
Update: July 16, 2013 | Rating: 4.5

Comment for "Increase temporary tablespace size in oracle"

0 comments

Post a Comment

Blog Archive