# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1699353622 -7200
# Node ID 8f4415990863eb1fef84e49e4ed8b0f9935eff3b
# Parent  77977f357b835b11b6929c6b3892a01efd81ac5c
List all tables.

diff -r 77977f357b83 -r 8f4415990863 oracle.rst
--- a/oracle.rst	Mon Jun 12 19:20:25 2023 +0300
+++ b/oracle.rst	Tue Nov 07 12:40:22 2023 +0200
@@ -159,6 +159,14 @@
 
   select sum(BYTES) from USER_EXTENTS;
 
+List all tables::
+
+  select * from DBA_TABLES;
+
+List table sizes::
+
+  select from DBA_SEGMENTS;
+
 Get LOB stored size::
 
   select sum(dbms_lob.getchunksize(COL))/1024/1024 MiB from TBL;