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, 160👍, 0💬

Popular Posts:

Conditional Statemen...

Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...

About dba.FYIcenter....

What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...

RAND() - Generating ...

How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...

Ending Stored Proced...

How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...

Creating a View with...

Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...