winserver 2012R2 安装oracle及创建表流程(推荐)

//第一步：查看数据库表空间位置

    select t1. name ,t2. name from v$tablespace t1,v$datafile t2 where t1.ts# = t2.ts#;

     //第二步：创建临时及默认表空间

     create temporary tablespace spacename_temp

     tempfile 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\spacename.DBF'

     size 50m

     autoextend on

     next 50m maxsize 20480m

     extent management local ;

     create tablespace spacename

     logging

     datafile '第一步的路径\tablespacename.DBF'

     size 50m

     autoextend on

     next 50m maxsize 20480m

     extent management local ;

     //第三步：创建用户并指定表空间

     create user username identified by password

     default tablespace spacename

     temporary tablespace spacename_temp;

    //第四步：给用户授予权限

    grant dba, connect ,resource to username;