-- 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);

alter tablespace rbs
  default storage(initial 5M next 5M MAXEXTENTS UNLIMITED);
alter rollback segment rbs1 offline;
alter rollback segment rbs2 offline;
alter rollback segment rbs3 offline;
alter rollback segment rbs4 offline;
alter rollback segment rbs5 offline;
alter rollback segment rbs6 offline;
alter rollback segment rbs7 offline;
alter rollback segment rbs8 offline;
alter rollback segment rbs9 offline;
alter rollback segment rbs10 offline;
alter rollback segment rbs11 offline;
alter rollback segment rbs12 offline;
alter rollback segment rbs13 offline;
alter rollback segment rbs14 offline;
alter rollback segment rbs15 offline;
alter rollback segment rbs16 offline;
alter rollback segment rbs17 offline;
alter rollback segment rbs18 offline;
alter rollback segment rbs19 offline;
alter rollback segment rbs20 offline;
alter rollback segment rbs21 offline;
alter rollback segment rbs22 offline;
alter rollback segment rbs23 offline;
alter rollback segment rbs24 offline;

alter rollback segment rbs1 storage (NEXT 5M MAXEXTENTS UNLIMITED);
alter rollback segment rbs2 storage (NEXT 5M MAXEXTENTS UNLIMITED);
alter rollback segment rbs3 storage (NEXT 5M MAXEXTENTS UNLIMITED);
alter rollback segment rbs4 storage (NEXT 5M MAXEXTENTS UNLIMITED);
alter rollback segment rbs5 storage (NEXT 5M MAXEXTENTS UNLIMITED);
alter rollback segment rbs6 storage (NEXT 5M MAXEXTENTS UNLIMITED);
alter rollback segment rbs7 storage (NEXT 5M MAXEXTENTS UNLIMITED);
alter rollback segment rbs8 storage (NEXT 5M MAXEXTENTS UNLIMITED);
alter rollback segment rbs9 storage (NEXT 5M MAXEXTENTS UNLIMITED);
alter rollback segment rbs10 storage (NEXT 5M MAXEXTENTS UNLIMITED);
alter rollback segment rbs11 storage (NEXT 5M MAXEXTENTS UNLIMITED);
alter rollback segment rbs12 storage (NEXT 5M MAXEXTENTS UNLIMITED);
alter rollback segment rbs13 storage (NEXT 5M MAXEXTENTS UNLIMITED);
alter rollback segment rbs14 storage (NEXT 5M MAXEXTENTS UNLIMITED);
alter rollback segment rbs15 storage (NEXT 5M MAXEXTENTS UNLIMITED);
alter rollback segment rbs16 storage (NEXT 5M MAXEXTENTS UNLIMITED);
alter rollback segment rbs1 online;
alter rollback segment rbs2 online;
alter rollback segment rbs3 online;
alter rollback segment rbs4 online;
alter rollback segment rbs5 online;
alter rollback segment rbs6 online;
alter rollback segment rbs7 online;
alter rollback segment rbs8 online;
alter rollback segment rbs9 online;
alter rollback segment rbs10 online;
alter rollback segment rbs11 online;
alter rollback segment rbs12 online;
alter rollback segment rbs13 online;
alter rollback segment rbs14 online;
alter rollback segment rbs15 online;
alter rollback segment rbs16 online;


----------------------------------------------------
-- How to create new rollback segments:
----------------------------------------------------
-- create public rollback segment rb1 tablespace rbs
-- storage ( 
-- 	initial		5M 
-- 	next 		5M 
-- 	minextents 	2 
-- 	maxextents 	121
-- 	optimal 	10M );
-- alter rollback segment rb1 online;

----------------------------------------------------
-- 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;

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

--
-- 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;
--
-- 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;

