DBA Hub

📋Steps in this guide1/1

Drop tablespace in oracle db

Imported guide

oracle configurationintermediate
by OracleDba
12 views
1

Overview

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
-- Drop a tablespace without removing the physical database files.
SQL❯
drop tablespace TESTING;
Tablespace dropped.
 
SQL❯
select file_name from dba_data_files where tablespace_name='TESTING';
no rows selected
-- Drop tablespace including the physical datafiles.
SQL❯
drop tablespace TESTING including contents and datafiles;
Tablespace dropped.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!