tablespaces
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| tablespaces [2020/02/20 09:30] – z0hpvk | tablespaces [2025/03/08 22:24] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 89: | Line 89: | ||
| <code SQL> | <code SQL> | ||
| -- Report on which data files can be shrunk | -- Report on which data files can be shrunk | ||
| - | set verify off | + | set verify off pagesize 50 linesize 120 |
| - | column file_name format | + | column file_name format |
| column smallest format 999,990 heading " | column smallest format 999,990 heading " | ||
| column currsize format 999,990 heading " | column currsize format 999,990 heading " | ||
tablespaces.1582191004.txt.gz · Last modified: 2025/03/08 22:23 (external edit)