AIX clustered server: Create JCR table spaces
This topic provides manual instructions for creating JCR table spaces for Oracle.
If you have run the setup-database script, you should not perform the steps below. As an alternative to creating JCR table spaces using the steps below, you can run the setup-database script to create the required JCR table spaces. In addition to creating JCR table spaces, the setup-database script automatically creates users and grants privileges.
- In the database directory, create the data directory data and the index directory index.
- Create tablespaces using the following commands as examples:
Substitute the values of environment for the following variables:
Ensure that the '.' is included in the variables when you substitute the values of environment with these variables.
- &jcrdb. is the name of the database you created to store user data.
- &dbpath. is the directory where you created the database; the default path is /oracle/oradata.
You must use the same table space names listed in the commands. The table space names cannot be customized or modified.
create tablespace ICMLFQ32 datafile '&dbpath./&jcrdb./data/&jcrdb._ICMLFQ32_01.dbf' size 300M reuse autoextend on next 10M maxsize UNLIMITED extent management local autoallocate;
create tablespace ICMLNF32 datafile '&dbpath./&jcrdb./data/&jcrdb._ICMLNF32_01.dbf' size 25M reuse autoextend on next 10M maxsize UNLIMITED extent management local autoallocate;
create tablespace ICMVFQ04 datafile '&dbpath./&jcrdb./data/&jcrdb._ICMVFQ04_01.dbf' size 25M reuse autoextend on next 10M maxsize UNLIMITED extent management local autoallocate;
create tablespace ICMSFQ04 datafile '&dbpath./&jcrdb./data/&jcrdb._ICMSFQ04_01.dbf' size 150M reuse autoextend on next 10M maxsize UNLIMITED extent management local autoallocate;
create tablespace ICMLSNDX datafile '&dbpath./&jcrdb./index/&jcrdb._ICMLSNDX_01.dbf' size 10M reuse autoextend on next 10M maxsize UNLIMITED extent management local autoallocate;
- Set the size, autoextend, and maxsize values according to environment. For example, you may want to change the maxsize to a set value rather than UNLIMITED.
- Consult Database Administrator for specific guidance about creating tablespaces for environment.
Refer to the Oracle command reference for more information about using the create tablespaces command.
Parent
AIX clustered server: Set up Oracle or Oracle RAC manuallyJanuary 4, 2012
2012/01/04 v7. Edition 2: Second edition includes corrections a... 2011/12/15 documentation refresh