Previous Topic

Next Topic

Book Contents

Book Index

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 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.