--- 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::