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.
⇒ Keep Data Files When Tablespace Dropped in Oracle
⇐ Rename a Tablespace in Oracle
2019-04-13, 1661🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...