connect SYS/change_on_install as SYSDBA

define ORACLE_HOME = &1
define ORACLE_SID  = &2

set echo on

spool CreateDBFiles.log


/*
 * -----------------------------------------------------------
 * DRSYS
 * -----------------------------------------------------------
 *   Used to support both "Oracle Text (formerly interMedia Text)" 
 *   and "Workspace Manager". All segments in this tablespace 
 *   will be owned by "CTXSYS" and "WKSYS" respectively.
 *   After a default installation, the objects in this
 *   tablespace will consume about 10MB.
 * -----------------------------------------------------------
 */

CREATE TABLESPACE "DRSYS"
  LOGGING
  DATAFILE 'C:\oracle\oradata\&ORACLE_SID\drsys01.dbf' SIZE 50M
  REUSE
  AUTOEXTEND ON
  NEXT 50M
  MAXSIZE 500M
  EXTENT MANAGEMENT LOCAL
  SEGMENT SPACE MANAGEMENT AUTO
/



/*
 * -----------------------------------------------------------
 * CWMLITE
 * -----------------------------------------------------------
 *   Used to support Oracle OLAP Services. All segments in this 
 *   tablespace will be owned by "OLAPSYS".
 *   After a default installation, the objects in this
 *   tablespace will consume about 13.3MB.
 * -----------------------------------------------------------
 */

CREATE TABLESPACE "CWMLITE"
  LOGGING
  DATAFILE 'C:\oracle\oradata\&ORACLE_SID\cwmlite01.dbf' SIZE 50M
  REUSE
  AUTOEXTEND ON
  NEXT 50M
  MAXSIZE 500M
  EXTENT MANAGEMENT LOCAL
  SEGMENT SPACE MANAGEMENT AUTO
/



/*
 * -----------------------------------------------------------
 * ODM
 * -----------------------------------------------------------
 *   Used to support Oracle Data Mining. All segments in this 
 *   tablespace will be owned by both "ODM" and "ODM_MTR".
 *   After a default installation, the objects in this
 *   tablespace will consume about 9.7MB. 
 * -----------------------------------------------------------
 */

CREATE TABLESPACE "ODM"
  LOGGING
  DATAFILE 'C:\oracle\oradata\&ORACLE_SID\odm01.dbf' SIZE 50M
  REUSE
  AUTOEXTEND ON
  NEXT 50M
  MAXSIZE 500M
  EXTENT MANAGEMENT LOCAL
  SEGMENT SPACE MANAGEMENT AUTO
/



/*
 * -----------------------------------------------------------
 * XDB
 * -----------------------------------------------------------
 *   Used to support Oracle's SQL XML management. Better known
 *   as XML DB. All segments in this tablespace will be
 *   owned by the "XDB" user. After a default installation,
 *   the objects in this tablespace will consume about 47MB.
 * -----------------------------------------------------------
 */

CREATE TABLESPACE "XDB"
  LOGGING
  DATAFILE 'C:\oracle\oradata\&ORACLE_SID\xdb01.dbf' SIZE 50M
  REUSE
  AUTOEXTEND ON
  NEXT 50M
  MAXSIZE 500M
  EXTENT MANAGEMENT LOCAL
  SEGMENT SPACE MANAGEMENT AUTO
/



/*
 * -----------------------------------------------------------
 * USERS
 * -----------------------------------------------------------
 *   This tablespace is created for storing user specific
 *   data segments. For developers and other users, this 
 *   is generally used as their default tablespaces.
 * -----------------------------------------------------------
 */

CREATE TABLESPACE "USERS"
  LOGGING
  DATAFILE 'C:\oracle\oradata\&ORACLE_SID\users01.dbf' SIZE 50M
  REUSE
  AUTOEXTEND ON
  NEXT  50M
  MAXSIZE 500M
  EXTENT MANAGEMENT LOCAL
  SEGMENT SPACE MANAGEMENT AUTO
/



/*
 * -----------------------------------------------------------
 * INDX
 * -----------------------------------------------------------
 *   This tablespace is created for storing user specific
 *   index segments. These are generally indexes that are 
 *   created on tables in the USERS tablespaces.
 * -----------------------------------------------------------
 */

CREATE TABLESPACE "INDX"
  LOGGING
  DATAFILE 'C:\oracle\oradata\&ORACLE_SID\indx01.dbf' SIZE 50M
  REUSE
  AUTOEXTEND ON
  NEXT  50M
  MAXSIZE 500M
  EXTENT MANAGEMENT LOCAL
  SEGMENT SPACE MANAGEMENT AUTO
/



/*
 * -----------------------------------------------------------
 * TOOLS
 * -----------------------------------------------------------
 *   This tablespace is created for storing segments related
 *   to Oracle tools. There is generally no use for this
 *   tablespaces as most tools use tablespaces with more of
 *   a descriptive name.
 * -----------------------------------------------------------
 */

/*
CREATE TABLESPACE "TOOLS"
  LOGGING
  DATAFILE 'C:\oracle\oradata\&ORACLE_SID\tools01.dbf' SIZE 50M
  REUSE
  AUTOEXTEND ON
  NEXT 50M
  MAXSIZE 500M
  EXTENT MANAGEMENT LOCAL
  SEGMENT SPACE MANAGEMENT AUTO
/
*/



/*
 * -----------------------------------------------------------
 * EXAMPLE
 * -----------------------------------------------------------
 *   This tablespace is used for storing segments related
 *   to the Demo Schemas. The demo schemas are created using
 *   the script: demoSchemas.sql
 * -----------------------------------------------------------
 */

/*
CREATE TABLESPACE "EXAMPLE"
  LOGGING
  DATAFILE 'C:\oracle\oradata\&ORACLE_SID\example01.dbf' SIZE 50M
  REUSE
  AUTOEXTEND ON
  NEXT 50M
  MAXSIZE 500M
  EXTENT MANAGEMENT LOCAL
  SEGMENT SPACE MANAGEMENT AUTO
/
*/


spool off

exit;