Toad World® Forums

Data base Table Space and Thier segment


#1

I am new to oracle.
Please clear my concept about the table space and segment.
Database is divided into tablespace on hardisk.
eg. data tablespace, index,undo etc
when do any drl or dml statement, in data base cache for each segment ,cache is load
like for data , data cache is loaded and when we changes the blocks then undo buffer is load in memory ,simirlary for the table that have index ,index cache is load in data baffer cache…


#2

Hello

I hope these links help you clarify your question about the difference between a tablespace and a segment

Tablespaces in Oracle
http://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces.htm#i1010516

Data Blocks, Extents, and Segments
http://docs.oracle.com/cd/B28359_01/server.111/b28318/logical.htm

Regards.