Collections:
Drop a Tablespace in Oracle
How To Drop a Tablespace in Oracle?
✍: FYIcenter.com
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.
2019-04-13, 791👍, 0💬
Popular Posts:
How To Create a Test Table for Transaction Testing in Oracle? If you want to practice DML statements...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How do you know if SQL Server is running on your local system in SQL Server? After installing SQL Se...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...