新建Oracle数据库

新建oracle数据库即新建表空间、用户，权限即可。

create temporary tablespace ydkf_temp 
tempfile 'C:\app\Gerrard\oradata\orcls\ydkf_temp.dbf' 
size 50m 
autoextend on 
next 50m maxsize 20480m 
extent management local; 


create tablespace ydkf_data 
logging 
datafile 'C:\app\Gerrard\oradata\orcls\ydkf_data.dbf' 
size 50m 
autoextend on 
next 50m maxsize 20480m 
extent management local; 

create user ydkf identified by laijieyao 
default tablespace ydkf_data 
temporary tablespace ydkf_temp; 

grant connect,resource,dba to ydkf;