Oracle - Drop a Tablespace in Oracle

Drop a Tablespace in Oracle

Q

How To Drop a Tablespace in Oracle?

✍: FYIcenter.com

A

If you have an existing tablespace and you don't want it anymore. You can delete a tablespace by using the DROP TABLESPACE statement as shown in the example below:

SQL> CREATE TABLESPACE my_space 
  2  DATAFILE '/temp/my_space.dbf' SIZE 10M;
Tablespace created.

SQL> DROP TABLESPACE my_space;
Tablespace dropped.

⇒Managing Oracle Tablespaces and Data Files

⇒⇒Oracle Database Tutorials

2016-10-17, 414👍, 0💬

Popular Posts:

"CREATE PROCEDURE" -...

How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...

What Are Logical/Boo...

What Are Logical/Boolean Operations in SQL Server Transact-SQL? Logical (Boolean) operations are per...

Generating CREATE VI...

How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...

Dispaly Part Time in...

How To Display a Past Time in Days, Hours and Minutes in MySQL? You have seen a lots of Websites are...

SQL Server Transact-...

Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...