[Oracle] logical structure (TableSpace → Segment → Extent → Block)

From the table above, we can see that a database is composed of multiple tablespaces, one tablespace is composed of multiple segments, and one segment is composed of multiple partitions (extent) A zone is composed of multiple blocks.

Store it for him. Later, he applied for 5 ㎡ from the manager of the granary. Who knows this year's bumper harvest, this 10㎡ is not enough for him at all, and next time I applied for 5 ㎡. I have to put rice in the past three or two days, and the leaders are tired of it. Wouldn't I be busy? Therefore, the leader approves that Michael can apply for 90 ㎡ at a time. In this way, Michael can leave the trouble to ask the leader to put rice in the place. However, with the increase of Michael Zhang in a year, the rice he had gained was more than a year later than a year, and 90 ㎡ was not enough for him. So he applied to the leaders again, but this time he was much more relaxed, only once, 90 ㎡ to get it... But soon, Michael's business was growing rapidly. There were more than just rice and apple! He applied for a 90 ㎡ place for Apple in the same way, and then added pineapple planting in the next year's business... In this way, Michael started his career. His real harvest was not enough for the granaries in the county. She directly bought the whole granary, reserve all crops. But in the second year, Michael Jacob had developed to the aquaculture industry, so he directly built several warehouses next to him and gave them a name (including the granary.

.

Create multiple tablespaces in the database and create tables in each tablespace. For example, we can assign multiple users to create table1, table2, and table3, table4, user1, and user2 under user1, table1 and table2 are different segments created in the tablespace. A column of data can be seen as a partition. After the partition is full, it will be expanded to form a table.