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

Popular Posts:

RAND() - Generating ...

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

Conditional Statemen...

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

sys.server_principal...

How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...

DATEADD() Function U...

How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...

Binary Literals in S...

What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...