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, 1677🔥, 0💬
Popular Posts:
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...