Differences between locally managed and dictionary managed tablespace in oracle database ?
meda Changed status to publish 16/07/2022
The difference between locally managed and dictionary managed tablespaces:
- In locally managed tablespace free extents are managed in the tablespace. But in dictionary managed tablespace it is managed by the data dictionary.
- Dictionary managed tablespaces are supported only for backward compatibility.
- The use of locally managed tablespace is recommended.
meda Edited answer 08/05/2022