📋Steps in this guide1/1

Add/drop Tempfile

-- Add tempfile to temp tablespace:

oracle configurationintermediate

by OracleDba

11 views

Add/drop Tempfile

-- Add tempfile to temp tablespace: -- Resize temp file: -- Drop tempfile:

Code/Command (click line numbers to comment):

1
2
3

alter tablespace TEMP1 add tempfile '/u01/dbaclass/tempfile/temp02.dbf' size 1G autoextend on next 200M;
alter database tempfile '/u01/dbaclass/tempfile/temp02.dbf' resize 2G;
ALTER DATABASE TEMPFILE '/u01/dbaclass/tempfile/temp02.dbf' DROP INCLUDING DATAFILES;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!