Create the database and tablespaces
After you install the Oracle database software, create the database instance and tablespaces. Make sure the Oracle server has sufficient space to accommodate the new tablespaces. The Oracle Central Designer software uses the following tablespaces by default.
Tablespace | Description | Minimum size |
---|---|---|
DESIGNER |
Main data tablespace |
100 MB. A 16k (16384 bytes) block size is required. Note: Depending on usage, you might need to increase the MB size. |
SYSTEM |
Main data tablespace |
500 MB. |
SYSAUX |
Main data tablespace |
250 MB. |
TEMP |
Temporary tablespace |
Always present in the Oracle database. |
UNDOTBS1 |
Main data tablespace |
200 MB. |
Note:
The tablespace names provided are the default names. Any names can be used for the tablespaces.Note:
If you use non-default names, you must specify them during the installation of the application server (by clicking Advanced on the Database Parameters page), so be sure you take note of them.Parent topic: Preparing the database server