Upgrading from Version 9.7.1

10.3 HotFix 1

Back Next

Create Tablespaces

You need to create tablespaces that the MDM Hub schemas require.

Create the tablespaces in the following sequence:

CMX_DATA

CMX_INDX

CMX_REPOS

CMX_TEMP

CMX_USER_TEMP

CMX_SYS_TEMP

Use the following statements to create tablespaces for the MDM Hub schemas:

CREATE TABLESPACE CMX_DATA PAGESIZE 32 K 
	MANAGED BY DATABASE USING ( FILE 'c:\dbhub9x\CMX_DATA\cmx_data01.dat' 500 M ) 
	EXTENTSIZE 16 
	AUTORESIZE YES 
	OVERHEAD 10.5 
	PREFETCHSIZE 16
	BUFFERPOOL CMX_POOL 
	
CREATE TABLESPACE CMX_INDX PAGESIZE 32 K 
	MANAGED BY DATABASE USING ( FILE 'c:\dbhub9x\CMX_INDX\cmx_indx01.dat' 500 M ) 
	EXTENTSIZE 16 
	AUTORESIZE YES 
	OVERHEAD 10.5 
	PREFETCHSIZE 16
	BUFFERPOOL CMX_POOL 
	
CREATE TABLESPACE CMX_REPOS PAGESIZE 32 K 
	MANAGED BY DATABASE USING ( FILE 'c:\dbhub9x\CMX_REPOS\cmx_repos01.dat' 500 M )
	EXTENTSIZE 16 
	AUTORESIZE YES 
	OVERHEAD 10.5 
	PREFETCHSIZE 16 
	BUFFERPOOL REPOS_POOL 
	
CREATE TABLESPACE CMX_TEMP PAGESIZE 32 K 
	MANAGED BY DATABASE USING ( FILE 'c:\dbhub9x\CMX_TEMP\cmx_temp01.dat' 500 M ) 
	EXTENTSIZE 16 
	AUTORESIZE YES 
	OVERHEAD 10.5 
	PREFETCHSIZE 16
	BUFFERPOOL CMX_POOL 
	
CREATE USER TEMPORARY TABLESPACE CMX_USER_TEMP PAGESIZE 32 K 
	MANAGED BY DATABASE USING ( FILE 'c:\dbhub9x\USER_TEMP\cmx_user_temp01.dat' 500 M ) 
	EXTENTSIZE 16 
	AUTORESIZE YES 
	OVERHEAD 10.5
	PREFETCHSIZE 16 
	BUFFERPOOL CMX_POOL

CREATE SYSTEM TEMPORARY TABLESPACE CMX_SYS_TEMP PAGESIZE 32 K
	MANAGED BY DATABASE USING ( FILE 'c:\dbhub9x\SYSTEM_TEMP\cmx_sys_temp01.dat' 500 M ) 
	EXTENTSIZE 16 
	AUTORESIZE YES 
	OVERHEAD 10.5 
	PREFETCHSIZE 16 
	BUFFERPOOL CMX_POOL

Optionally, to create tablespaces with the dropped table recovery feature enabled, add the following clause to the

CREATE TABLESPACE

statement:

DROPPED TABLE RECOVERY ON

Rename Saved Search

Table of Contents

Upgrading from Version 9.7.1

Upgrading from Version 9.7.1

Create Tablespaces

Create Tablespaces