From: Knut Talman Newsgroups: comp.databases.oracle.server Subject: Re: About DBA_SEGMENTS Date: Wed, 06 Jun 2001 19:01:16 +0200 Organization: myToys.de GmbH Lines: 17 Message-ID: <3B1E61DC.DF25CD5@mytoys.de> References: <9flms3$so51@imsp212.netvigator.com> NNTP-Posting-Host: h-213.61.134.194.host.de.colt.net Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: crusher.de.colt.net 991846877 14498 213.61.134.194 (6 Jun 2001 17:01:17 GMT) X-Complaints-To: usenet@news1.de.colt.net NNTP-Posting-Date: 6 Jun 2001 17:01:17 GMT X-Mailer: Mozilla 4.77 [de] (X11; U; Linux 2.4.2-2 i686) X-Accept-Language: de > Where does the 'segment_name' of the DBA_SEGMENTS view come from? > > It seems no CREATE SEGMENTS statement in Oracle. There is no dedicated segment in Oracle, every table, index etc. is a segment which you can see in dba_segments (refer to the doc for further information on Oracle concepts). Regards, Knut -- Knut Talman Fon +49 30 72 62 01 411 dba@myToys.de Fax +49 30 72 62 01 222 The degree of normality in a database is inversely proportional to that of its DBA