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

Popular Posts:

Passing Values to St...

How To Provide Values to Stored Procedure Parameters in SQL Server Transact-SQL? If a stored procedu...

CAST() - Converting ...

How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...

DATEADD() Function U...

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

Conditional Statemen...

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

Managing Security, L...

Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...