In this exercise, you will create tablespaces and change their characteristics. Follow these steps:

1. Connect to the database as user SYSTEM.

2. Create a tablespace in a suitable directoryany directory on which the Oracle owner has write permission will do. This is an example:

create tablespace newtbs

datafile '/home/db12c/oradata/newtbs_01.dbf' size 10m

extent management local autoallocate

segment space management auto;

This command specifies the options that are the default. Nonetheless, it may be considered good practice to do this, to make the statement self-documenting.