Differences

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

--- tablespaces [2019/10/18 14:25] – z0hpvk
+++ tablespaces [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 81: / Line 81: @@
 </code>
-==== Shrink Data Files ====
+==== Default Tablespaces ====
-<code>
+<code SQL>
+SELECT * FROM database_properties WHERE property_name like '%TABLESPACE';
+</code>
+==== Resize Data Files ====
+<code SQL>
 -- Report on which data files can be shrunk
-set verify off
+set verify off pagesize 50 linesize 120
-column file_name format a50 word_wrapped
+column file_name format a60 word_wrapped
 column smallest format 999,990 heading "Smallest|Size|Poss."
 column currsize format 999,990 heading "Current|Size"