Oracle新建数据库

create tablespace HNNW logging datafile ‘\app\oratable_space\HNNW_20200114.dbf‘ size 50m autoextend on next 50m maxsize 20480m extent management local;

create temporary tablespace HNNW_ls
tempfile ‘\app\table_space\HNNW_20200114.dbf‘
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;

create user ias identified by ias
default tablespace HNNW
temporary tablespace HNNW_ls;

grant connect,resource,dba to ias;

Oracle新建数据库

标签：file   ant   tables   xtend   taf   temp   oca   extent   use