Describe how tables, tablespaces, and datafiles fit together.
Tablespaces and Datafiles
Now that you have seen how to create a table with columns, let us add some details to the CREATE TABLE statement. These additional parameters define the way that the table uses physical storage space in the database. Before describing the syntax, a little background information is needed. Before creating a table, you create a database and define the total storage space it can use. When you create a table without specifying any space-related parameters, Oracle allocates a predefined default amount of blocks within a predefined default tablespace to that table. Once you begin to add rows to the table, the row data is written to a block and the blocks are filled sequentially for each table. Use the following series of images below to see how a database grows.
The next lesson shows you how to specify the space parameters when creating a table.
Oracle Database SQL