Differences

This shows you the differences between two versions of the page.

--- database:oracle:drop-tablespace [2023/03/09 15:43] – odefta
+++ database:oracle:drop-tablespace [2023/07/04 19:36] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-====== Completely drop the tablespace and the associated data files ======
+====== Completely drop a tablespace and all the associated data files ======
 ===== Check data files location =====
@@ Line 20: / Line 20: @@
 The ST_SERVERLOG tablespace has 2 data files:
-  * /opt/oracle/oradata/ORACLE19C/datafile/o1_mf_st_filet_js7jp8wx_.dbf
+  * /opt/oracle/oradata/ORACLE19C/datafile/o1_mf_st_serve_js7jhf9y_.dbf
-  * /opt/oracle/oradata/ORACLE19C/datafile/o1_mf_st_filet_js7jrfy1_.dbf
+  * /opt/oracle/oradata/ORACLE19C/datafile/o1_mf_st_serve_js7jqjb3_.dbf
 ===== Remove tablespace =====
@@ Line 29: / Line 29: @@
 </code>
-Note that this will not remove the data files from the disk, so the space will remain occupied.
+<note>
+This will not remove the data files from the disk, so the space will remain occupied.
+</note>
 ===== Drop data files =====