In this chapter you will learn to
• 052.6.1 Work with Tablespaces and Datafiles
• 052.6.2 Create and Manage Tablespaces
• 052.6.3 Handle Space Management in Tablespaces
The preceding two chapters dealt with the instance and the sessions against it: processes and memory structures. This chapter begins the investigation of the database itself. All data processing occurs in memory, in the instance, but data storage occurs in the database on disk. The database consists of three file types: the controlfile, the online redo log files, and the datafiles. Data is stored in the datafiles.
Users never see a physical datafile. All they see are logical segments. System administrators never see a logical segment. All ...