sqlplus system/manager@matrix SQL> create user medtronic identified by medtronic; grant dba to medtronic; CREATE TABLESPACE "MEDTRONIC_DATA" DATAFILE 'C:/oracle/oradata/matrix/med_d01.dbf' SIZE 157286400 REUSE AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M DEFAULT STORAGE(INITIAL 262144 NEXT 262144 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 1) ONLINE PERMANENT ; CREATE TABLESPACE "MEDTRONIC_INDEX" DATAFILE 'C:/oracle/oradata/matrix/med_i01.dbf' SIZE 157286400 REUSE AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M DEFAULT STORAGE(INITIAL 262144 NEXT 262144 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 1) ONLINE PERMANENT ; drop tablespace MEDTRONIC_DATA including contents and datafiles; drop tablespace MEDTRONIC_INDEX including contents and datafiles; drop user medtronic cascade;