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