CREATE TABLESPACE
tablespace_name
DATAFILE 'D:\ProgramFiles\oracle\product\10.2.0\db_1\oradata\
databasefile_name.DBF'
SIZE 200M REUSE AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED DEFAULT STORAGE(INITIAL 512K NEXT 1M MINEXTENTS 1 MAXEXTENTS 999) ONLINE;
create user
user_name identified by
user_name
default tablespace
tablespace_name
;
grant dba,connect,resource to
user_name;