DBA Hub

📋Steps in this guide1/2

How To Drop And Recreate Temp Tablespace In Oracle.

Find the existing temp tablespace details :

oracle configurationintermediate
by OracleDba
13 views
1

Overview

- Find the existing temp tablespace details : Find the existing temp tablespace details : Find the existing temp tablespace details :

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
SQL> select tablespace_name,file_name from dba_temp_files;

CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE ‘/u01/app/oradata/PRIM/temp01′ SIZE 5G;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP1;

SELECT b.tablespace,b.segfile#,b.segblk#,b.blocks,a.sid,a.serial#,a.username,a.osuser, a.statusFROM v$session a,v$sort_usage bWHERE a.saddr = b.session_addr;

ALTER SYSTEM KILL SESSION 'SID,SERIAL#' IMMEDIATE;
2

Section 2

Code/Command (click line numbers to comment):

1
DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!