Applies to:
You can customize the data file location of the OpenPages® table spaces.
Procedure
-
Log on to the Oracle database server as the user who installed Oracle.
-
Go to the /OP_<version>_Main/OP_<version>_Configuration/Database/ORACLE/INSTALL_SCRIPTS
directory.
-
Open the create-opx-tablespaces.sql script in a text editor.
-
Replace the
&&3 parameter with the full path to the data file.
For example, suppose that you want to customize the location of the
opx_dflt_data_ts data
file:
SELECT lower('&&opx_dflt_data_ts') lcase_name FROM dual;
create tablespace &&opx_dflt_data_ts datafile '&&3/&v_lcase_name..dbf'
size 512 M reuse autoextend on next 128 M maxsize 1024 M &&encrypt_var;
Replace
&&3 with the full
path:
SELECT lower('&&opx_dflt_data_ts') lcase_name FROM dual;
create tablespace &&opx_dflt_data_ts datafile '/u01/oradata/OP/&v_lcase_name..dbf'
size 512 M reuse autoextend on next 128 M maxsize 1024 M &&encrypt_var;
Note: Do not modify the &v_lcase_name..dbf parameter. The table space name is
read from the sql-wrapper.sql file.