Creating tablespaces

The CIS installation requires two tablespaces, one permanent and one temporary, on the CIS computer:

The permanent tablespace houses the CIS schema.
The temporary tablespace is used for temporary data storage.

The names of the tablespaces can be anything that meets your naming conventions. When you install CIS, you indicate the names of the tablespaces you created.

Note: When you create the tablespaces, make sure that the LOGGING option is enabled for BLOB and CLOB objects. For more information, see Ensuring that LOGGING is enabled.

You can use the following script as a model for creating the tablespaces. For larger studies, you might need to increase the size of the tablespaces.

CREATE TABLESPACE permanent_tablespace_name
DATAFILE 'PATH\permanent_tablespace_name_01.dbf' SIZE 200m
AUTOEXTEND ON NEXT 10m
DEFAULT STORAGE (
INITIAL 128K
NEXT 128K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0);

CREATE TEMPORARY TABLESPACE temp_tablespace_name
TEMPFILE 'PATH\temp_tablespace_name_01.dbf' SIZE 350m
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1m;