Recreate tablespace and user

connect system

drop user user1 cascade;
drop tablespace user1 including contents and datafiles;

create tablespace tablespace1
	datafile 'D:/oracle/product/10.2.0/oradata/ORCL/tablespace1.dbf' 
	size 100M
	REUSE
	AUTOEXTEND ON NEXT 10M
	extent management local
	segment space management auto
	nologging;

create user user1 identified by user1password
	default tablespace tablespace1 temporary tablespace temp;

grant connect, resource to user1 ;