-- tablespace qdas_default will be used for qs-stat
--alter tablespace users
--  default storage(initial 10M next 50M);
--
alter tablespace temp
  default storage(initial 10M next 50M);


----------------------------------------------------
-- Extents of the tablespace are automatically done 
-- by Oracle
----------------------------------------------------
create tablespace qdas_default
  datafile '<pathname\withinstancename>\qdas_default.dbf' size 10 M  
  AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
  EXTENT MANAGEMENT LOCAL AUTOALLOCATE NOLOGGING
  SEGMENT SPACE MANAGEMENT AUTO;

-- If a separate index tablespace is required, un-comment the following command:
-- create tablespace qdas_def_ix
--   datafile '<pathname\withinstancename>\qdas_def_ix.dbf' size 10 M  
--   AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
--   EXTENT MANAGEMENT LOCAL AUTOALLOCATE NOLOGGING
--   SEGMENT SPACE MANAGEMENT AUTO;

create tablespace qwert_table
  datafile '<pathname\withinstancename>\qwert_tab.dbf' size 100M 
  AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
  EXTENT MANAGEMENT LOCAL AUTOALLOCATE NOLOGGING
  SEGMENT SPACE MANAGEMENT AUTO;

create tablespace qmerk_table
  datafile '<pathname\withinstancename>\qmerk_tab.dbf' size 10M
  AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
  EXTENT MANAGEMENT LOCAL AUTOALLOCATE NOLOGGING
  SEGMENT SPACE MANAGEMENT AUTO;

--
-- The tablespace for the values should reside on another harddisk than the
-- tablespace for the index of the values
--
create tablespace qwert_index
  datafile '<pathname\withinstancename_butnotthesamedriveas_qwert_table>\qwert_ind.dbf' size 100M 
  AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
  EXTENT MANAGEMENT LOCAL AUTOALLOCATE NOLOGGING
  SEGMENT SPACE MANAGEMENT AUTO;
--
-- The tablespace for the characteristics should reside on another harddisk than the
-- tablespace for the index of the characteristics (only necessary, if we expect a lot of characteristics
--
create tablespace qmerk_index
  datafile '<pathname\withinstancename_butnotthesamedriveas_qmerk_table>\qmerk_ind.dbf' size 10M 
  AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
  EXTENT MANAGEMENT LOCAL AUTOALLOCATE NOLOGGING
  SEGMENT SPACE MANAGEMENT AUTO;

