tips: oracle.rst@27d4d6c15cb4 (annotated)

1403 8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	1	.. -- coding: utf-8; --
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	2	.. include:: HEADER.rst
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	3
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	4	==================
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	5	Oracle database.
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	6	==================
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	7	.. contents::
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	8
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	9	Oracle database development environment.
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	10	========================================
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	11
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	12	http://en.wikipedia.org/wiki/Oracle_SQL_Developer
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	13	Integrated development environment (IDE) for working with
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	14	SQL/PLSql in Oracle databases.
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	15	http://en.wikipedia.org/wiki/SQL*Plus
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	16	An Oracle database client that can run SQL and PL/SQL commands
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	17	and display their results.
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	18	http://en.wikipedia.org/wiki/Oracle_Forms
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	19	Is a software product for creating screens that interact with an
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	20	Oracle database. It has an IDE including an object navigator,
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	21	property sheet and code editor that uses PL/SQL.
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	22	http://en.wikipedia.org/wiki/Oracle_JDeveloper
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	23	JDeveloper is a freeware IDE supplied by Oracle Corporation. It
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	24	offers features for development in Java, XML, SQL and PL/SQL,
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	25	HTML, JavaScript, BPEL and PHP.
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	26	http://en.wikipedia.org/wiki/Oracle_Reports
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	27	Oracle Reports is a tool for developing reports against data
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	28	stored in an Oracle database.
8f86324134d6 Oracle database development environment. Oleksandr Gavenko <gavenkoa@gmail.com> parents: diff changeset	29
1462 27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	30	Информация о таблицах в БД Oracle.
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	31	==================================
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	32
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	33	Список таблиц::
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	34
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	35	select * from user_tables;
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	36
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	37	Занимаемый размер таблиц и индексов::
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	38
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	39	select segment_name, segment_type, sum(bytes) from user_extents
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	40	group by segment_name, segment_type order by sum(bytes);
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	41
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	42	select sum(bytes) from user_extents;
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	43
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	44	Список индексов по таблицам::
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	45
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	46	select * from user_indexes order by table_name;
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	47
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	48	Список размеров индексов по таблицам::
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	49
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	50	select index_name, table_name, sum(user_extents.bytes) as bytes from user_indexes
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	51	left outer join user_extents on user_extents.segment_name = table_name
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	52	group by index_name, table_name
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	53	order by table_name;
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	54
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	55	Список ограничений::
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	56
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	57	select * from user_constraints;
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	58
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	59	Используемое пространство таблиц::
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	60
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	61	select distinct tablespace_name from user_tables;
27d4d6c15cb4 Информация о таблицах в БД Oracle. Oleksandr Gavenko <gavenkoa@gmail.com> parents: 1403 diff changeset	62

author	Oleksandr Gavenko <gavenkoa@gmail.com>
	Mon, 11 Feb 2013 11:31:40 +0200
changeset 1462	27d4d6c15cb4
parent 1403	8f86324134d6
child 1482	1a012d9fe613
permissions	-rw-r--r--