--alter tablespace user_data
alter tablespace users
  default storage(initial 100K next 500K);
--alter tablespace temporary_data
alter tablespace temp
  default storage(initial 100K next 500K);

alter tablespace rbs
  default storage(initial 5M next 5M);
alter rollback segment rbs0 offline;
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 rbs0 storage (NEXT 5M MAXEXTENTS UNLIMITED);
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;


create tablespace qdas_default
  datafile 'qdas_default.dbf' size 3 M reuse 
  autoextend on next 10 M maxsize unlimited 
  default storage(initial 10 K next 50 K maxextents unlimited);
create tablespace qwert_table
  datafile 'qwert_tab.dbf' size 10M reuse 
  autoextend on next 10 M maxsize unlimited 
  default storage(initial 1 M next 5 M maxextents unlimited);
create tablespace qmerk_table
  datafile 'qmerk_tab.dbf' size 10M reuse 
  autoextend on next 10 M maxsize unlimited
  default storage(initial 1 M next 5 M maxextents unlimited);
create tablespace qwert_index
  datafile 'qwert_ind.dbf' size 10M reuse
  autoextend on next 10 M maxsize unlimited
  default storage(initial 1 M next 5 M maxextents unlimited);
create tablespace qmerk_index
  datafile 'qmerk_ind.dbf' size 10M reuse
  autoextend on next 10 M maxsize unlimited
  default storage(initial 1 M next 5 M maxextents unlimited);

