oracle一个数据库的建立过程

--# 1.创建临时表空间

 create temporary tablespace finance_temp tempfile 'D:\Oracle\finance_temp.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local; 

--# 2.创建表空间

 create tablespace finance logging datafile 'D:\Oracle\finance.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local; 

--# 3.创建用户

 create user finance identified by finance default tablespace finance temporary tablespace finance_temp; 

--# 4.用户授权

 grant connect,resource,dba to finance; 

--#更改用户密码 sys/orcl登录，执行下面语句

alter user finance identified by newpassword;

下面语句稍微改下就可以直接复制到sqlplus里直接运行： 

create temporary tablespace finance_temp tempfile 'D:\Oracle\finance_temp.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local; 

 create tablespace finance logging datafile 'D:\Oracle\finance.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local; 

 create user finance identified by finance default tablespace finance temporary tablespace finance_temp; 

 grant connect,resource,dba to finance;