Sysaux and system are for internal database objects

Figure 7-1 includes the following:

✓ Logical tablespace: This stores data tables for the user.

As you add objects and tables grow, Oracle manages the size of these things:

✓ Segments are any objects requiring storage.

TABLESPACE_NAME FILE_NAME
---------------- ---------------------------------------------EXAMPLE /u01/app/oracle/oradata/dev12c/example01.dbf MY_DATA /u01/app/oracle/oradata/dev12c/my_data01.dbf SYSAUX /u01/app/oracle/oradata/dev12c/sysaux01.dbf SYSTEM /u01/app/oracle/oradata/dev12c/system01.dbf UNDOTBS1 /u01/app/oracle/oradata/dev12c/undotbs01.dbf USERS /u01/app/oracle/oradata/dev12c/users01.dbf

6 rows selected.

138
	Figure 7-2: Tablespace manage- ment.

From the Tablespaces management screen, you can choose Actions➪Create to create a tablespace for storing application data tables, as shown in Figure 7-3.