Table of Contents

Oracle Database - Recursive call caused by space requests

About

Recursive calls can be performed to satisfy requests for space due to :

This is generally not a problem with locally managed tablespace where space is managed as bitmaps in the datafile headers. It can happen with dictionary-managed tablespace, where space is managed in database tables much like your own data is managed.

By default from the version 9iR2, the system tablespace is created as a locally managed tablespace and you can't create any dictionary-managed tablespace