Solaris stand-alone: 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.

  1. In the database directory, create the data directory data and the index directory index.

  2. Create tablespaces using the following commands as examples:

      Substitute the values of environment for the following 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.

      Ensure that the '.' is included in the variables when you substitute the values of environment with these variables.

      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;

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

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

Set up Oracle manually January 4, 2012

  2012/01/04 v7. Edition 2: Second edition includes corrections a... 2011/12/15 documentation refresh


        +

        Search Tips   |   Advanced Search