Oracle DB initial size
One answer
The question is a little vague, a database default tablespace maybe 1 GB in size. This does not include any redo log files and any other files required to support the Oracle instance on the file system. Also, the default tablespace USER and TEMP are avoided since our doc suggest that each CLM user (schemas) own their default and temp tablespaces.
Looking at the scripts to create the CLM solution, the 1 GB initial size becomes irrelevant. The Tool by default will required close to 5 GB of Disk space.
PLease review the following two links
More Control over the DB2 Data Warehouse Setuphttps://jazz.net/wiki/bin/view/Main/MoreControlOverTheOracleDataWarehouseSetup
The Total size for the DW becomes 1.2GB.
The recommended scripts for each of the product recommend to start the Tablespace size to 1 GB each.
Setting up an Oracle databasehttp://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m6/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_oracle.html
Comments
Thanks Philippe, you are right. The question was vague.
The issue is the we already have an oracle database used for other purposes. Adding at least 4 additional table spaces, 1GB in size each, is somewhat painful. The question was, is it really necessary to start with a 1GB size for each table space?
Good planning will save you a lot of headache down the track. CLM data can grow very fast, so starting with a small tablespace size offers virtually no benefit.