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, 3307🔥, 0💬
Popular Posts:
How To Get the Definition of a View Out of the SQL Server in SQL Server? If you want get the definit...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...