01.创建表空间 权限

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;