List all tables.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Tue, 07 Nov 2023 12:40:22 +0200
changeset 2569 8f4415990863
parent 2568 77977f357b83
child 2570 f1aad564e5d5
List all tables.
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;