|
|
| Re: table & segment [message #62156 is a reply to message #62133] |
Wed, 30 June 2004 10:07   |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
Both indexes and tables are common types of segments. A segment is a group one or more extents.
select distinct segment_type from dba_segments;
CACHE
CLUSTER
INDEX
INDEX PARTITION
LOBINDEX
LOBSEGMENT
NESTED TABLE
ROLLBACK
TABLE
TABLE PARTITION
TYPE2 UNDO
|
|
|
|
| Re: table & segment [message #62186 is a reply to message #62156] |
Sat, 03 July 2004 03:38 |
mb
Messages: 51
Registered: March 2001
|
Member |
|
|
is it correct that:
we have 1 or more segment for every table or index ?
which of the system tables has more than one segment?
if it is correct and we know that segment is the physical concept ,so is it correct that :
table is logical concept correspoding to physical concept segment?
thanks a lot
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
