What is a dictionary-managed tablespace?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is a dictionary-managed tablespace?
Rating:
A tablespace that stores metadata regarding free/used extents and extent allocation in the data dictionary is called a dictionary-managed tablespace. Oracle uses the data dictionary to track allocated and free extents for dictionary-managed tablespaces. Data regarding free extents is recorded in the FET$ data dictionary table, whereas data regarding used extents is recorded in the UET$ data dictionary table. Oracle automatically updates these tables whenever an extent is allocated or freed for reuse in a dictionary-managed tablespace.
Rating:
Was this information helpful?
Other articles
- What is password file authentication?
- What is a tablespace?
- How is a constraint enabled?
- What is a FOREIGN KEY constraint?
- What is a profile?