Oracle database management tracks its computers data storage with the help of information stored in the system or tablespace. The system or tablespace contains the data dictionary and often (by default) indexes and clusters. A data dictionary consists of a special collection of tables that contains information about all user-objects in the database.

The oracle RDBMS also supports “locally managed” tablespaces that store space management information in bitmaps in their own headers rather than in the tablespace or system (as happens with the default “dictionary-managed” tablespace).      orlOracle has also introduced the tablespace or system, which contains some of the tables formerly stored in the tablespace (system), along with objects for other tools such as OEM, which previously required its own …

Read More →