oracle.rst
changeset 1623 4496f9e49b7b
parent 1622 dec1fd4222e8
child 1624 baf11017516f
--- a/oracle.rst	Tue Sep 30 19:05:49 2014 +0300
+++ b/oracle.rst	Tue Sep 30 19:09:41 2014 +0300
@@ -41,42 +41,42 @@
   end;
   /
 
-Информация о таблицах в БД Oracle.
-==================================
+Database info.
+==============
 
-Список таблиц::
+List of current user owned tables::
 
-  select * from user_tables;
+  select * from USER_TABLES;
 
-Занимаемый размер таблиц и индексов::
+List of current user table sizes::
 
-  select segment_name, segment_type, sum(bytes) from user_extents
-    group by segment_name, segment_type order by sum(bytes);
+  select SEGMENT_NAME, SEGMENT_TYPE, sum(BYTES) from USER_EXTENTS
+    group by SEGMENT_NAME, SEGMENT_TYPE order by sum(BYTES);
 
-  select sum(bytes) from user_extents;
+  select sum(BYTES) from USER_EXTENTS;
 
-Список индексов по таблицам::
+Tables indexes::
 
-  select * from user_indexes order by table_name;
+  select * from USER_INDEXES order by TABLE_NAME;
 
-Список размеров индексов по таблицам::
+List of index sizes::
 
   select index_name, table_name, sum(user_extents.bytes) as bytes from user_indexes
     left outer join user_extents on user_extents.segment_name = table_name
     group by index_name, table_name
     order by table_name;
 
-Список ограничений::
+List of currenct user constraints::
 
-  select * from user_constraints;
+  select * from USER_CONSTRAINTS;
 
-Используемое пространство таблиц::
+List of tablespaces::
 
-  select distinct tablespace_name from user_tables;
+  select distinct TABLESPACE_NAME from USER_TABLES;
 
 List of current user permissions::
 
-  select * from session_privs;
+  select * from SESSION_PRIVS;
 
 List of user permissions to tables::