1.6. Behind Tables
What is a table? Is it a file, a block, or a stream of bytes? Here we look at tables logically and physically.
1.6.1. Application Tablespaces
All table data is ultimately stored in host operating system files; but, the insertion of rows never specifically identifies a host file.
The first step is to create an intermediate logical layer called a tablespace with a CREATE TABLESPACE statement. This statement includes the host pathnames of one or more host files that are to be created. The CREATE TABLESPACE statement creates the files mentioned in the statement, formats the files, and stores information in the Oracle data dictionary. The data dictionary information tracks the fact that a tablespace is made up of specific files. ...