oracle建立表空间

create temporary tablespace moyacq_temp tempfile 'H:\app\giianhui\oradata\moyacq\moyacq_temp' size 500M autoextend on next 50M maxsize 1024M extent management local;


create tablespace moyacq_normal datafile 'H:\app\giianhui\oradata\moyacq\moyacq_normal' size 1024M autoextend on next 50M maxsize 8196M extent management local;


create user moyacq identified by moyacq default tablespace moyacq_normal temporary tablespace moyacq_temp;


grant connect,resource,dba to moyacq;