drop user bugbase cascade;
DROP TABLESPACE bugbase INCLUDING CONTENTS AND DATAFILES;
CREATE TABLESPACE bugbase
DATAFILE 'c:\bugbase.dbf' SIZE 1000M
UNIFORM SIZE 128k;
create user bugbase identified by bugbase default tablespace bugbase;
grant dba,resource,connect to bugbase;
commit;
imp bugbase/bugbase@orcl file=d:\bugbase.dmp full=y ignore=y
DROP TABLESPACE bugbase INCLUDING CONTENTS AND DATAFILES;
CREATE TABLESPACE bugbase
DATAFILE 'c:\bugbase.dbf' SIZE 1000M
UNIFORM SIZE 128k;
create user bugbase identified by bugbase default tablespace bugbase;
grant dba,resource,connect to bugbase;
commit;
imp bugbase/bugbase@orcl file=d:\bugbase.dmp full=y ignore=y