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. ...
Get Programming Oracle® Triggers and Stored Procedures, Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
