Oracle Audio Technologies Retail Place 12.2 用户手册

Creating the Default Tablespaces

Oracle® Retail Place Installation Guide

When you run the Oracle installer, schemas and tables for the application get installed 
on the database you create. For the schemas and tables to install successfully, the 
database must include certain default tablespaces. 

Use the Oracle 10g Database Configuration Assistant to create a default database with 
the tablespaces mentioned in 

. For more 

information on using the Oracle 10g Database Configuration Assistant, see the Oracle 
10g Release 2 Installation documentation.

You must also create a default user account, that can be later specified to the Oracle 
Installer. The Oracle Installer connects to the Place database, using this user account, 
and installs the schemas and tables.

To create a user account:

At the SQL prompt, type the following statement to create an user and set DATA_
01 as the default tablespace:

CREATE USER <USERNAME> IDENTIFIED BY <USERNAME>

DEFAULT TABLESPACE DATA_01;

Once the user is created, type the following statements to grant access privileges to 
the user:

GRANT CONNECT,RESOURCE,CREATE ANY TABLE,CREATE ANY SYNONYM,CREATE VIEW TO 

<USERNAME>;

exec dbms_java.grant_permission( 

'<USERNAME>','SYS:java.lang.RuntimePermission', 'getClassLoader', '' )

DATA_01

Required. Application tablespace for Place. 
Recommended size: 5 GB.

INDEX_01

Required. Application tablespace for the indexes of Place, STG, 
and ASH. 
Recommended size: 5 GB.

SYSTEM

System tablespace used for metadata. 

SUSAUX

System tablespace used for system monitoring.

TEMP

System tablespace used for temporary system swap space.

RBS

System tablespace for automatically resolving data write clashes. 

The sizes of tablespaces depend on the amount of data being stored. 

For any sizing recommendations, see