SQL语句

登录：sys as sysdba

检查当前实例：select instance_name from v$instance;

创建表空间：（需在此之前建立文件夹C:/tbspace）create tablespace scott_tb_space datafile 'c:/tbspace/scott_tb_space.dbf' size 200m;

创建用户：create user scottt identified by tiger default tablespace scott_tb_space;

给用户授权：grant dba to scottt;

截图如下：

 

笔记截图