首页 > 技术文章 > SQL语句

Jane-share 2021-05-26 14:34 原文

登录: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;

截图如下:

 

笔记截图

 

 

推荐阅读