If you configured your database with Automatic Storage Management, you might need to
perform additional manual instructions to create JCR table spaces when you use the Database Transfer
option in the Configuration Wizard . If you select the option to let the
wizard create your database schemas and assign permissions, you must perform the steps in this topic
after you run the setup database script.
Procedure
- Create table spaces using the following commands as examples:
Note: - If you plan on customizing your table space names, you must ensure that the customized table
space names are used during database transfer. Custom table spaces must exist prior to performing
database
transfer.
- ASM_disk_group_name is the disk group name that you used to configure your
Automatic Storage Management environment.
- Ensure that the '.' is included in the variables when you substitute the values of your
environment with these variables.
create tablespace
ICMLFQ32
datafile '+ASM_disk_group_name' size
300M
reuse
autoextend on next 10M
maxsize
UNLIMITED
extent management
local
autoallocate;
create tablespace
ICMLNF32
datafile '+ASM_disk_group_name' size
25M
reuse
autoextend on next 10M
maxsize
UNLIMITED
extent management
local
autoallocate;
create tablespace
ICMVFQ04
datafile '+ASM_disk_group_name' size
25M
reuse
autoextend on next 10M
maxsize
UNLIMITED
extent management
local
autoallocate;
create tablespace
ICMSFQ04
datafile '+ASM_disk_group_name' size
150M
reuse
autoextend on next 10M
maxsize
UNLIMITED
extent management
local
autoallocate;
create tablespace
ICMLSNDX
datafile '+ASM_disk_group_name' size
10M
reuse
autoextend on next 10M
maxsize
UNLIMITED
extent management
local
autoallocate;
- Set the size, autoextend, and
maxsize values according to your environment. For example, you may want to
change the maxsize to a set value rather than UNLIMITED.
- Consult your Database Administrator for specific guidance about creating tablespaces for your
environment.
- Refer to the Oracle command reference for more
information about using the create tablespaces command.
- Ensure the database is registered with the Oracle listener. Use the tnsnames.ora file to describe this database and recycle the listener.