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 Central Designer software uses the following tablespaces by default.
Tablespace descriptions and sizes
Tablespace |
Description |
Minimum size |
---|---|---|
DESIGNER |
Main data tablespace |
100 MB. For Oracle 12c databases, a 16k (16384 bytes) block size is required. Note: Depending on usage, you might need to increase the MB size. |
DESIGNER_BIGINDEX |
Index tablespace |
10 MB with 16k (16384 bytes) block size. Note: Do not create this tablespace for Oracle 12c databases. |
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.
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.
Copyright © 2007, 2016 Oracle and/or its affiliates. All rights reserved.