|
What are the ways tablespaces can be managed and how do they differ?- Objects can be assigned to a table space.
- The related objects can be then grouped together.
- Table space can also be managed using extents. Extents consist of a specific number of contiguous data blocks.
- For the required extent, the free extent closest in size is determined.
- Tablespaces allocate space in extents.
- Tablespaces can use two different methods to keep track of their free and used space:
1. Locally managed tablespaces: Extent management by the bitmaps.
2. Dictionary managed tablespaces: Extent management by the data dictionary.
- When you create a tablespace, choose one of these methods of space management. Later, the management method can be changed with the DBMS_SPACE_ADMIN PL/SQL package.
|
