ORACLE新建表空间、用户和授权

登录Oracle ：>sqlplus sysadmin/sysadmin123 as sysdba

1、 sys@meeting as sysdba 或者 sqlplus /nolog
meeting 网络服务名
2、查询数据库实例名称

 select instance_name from v$instance;

3、修改sys密码

 alter user sys identified by sys123456

4、创建表空间

create tablespace meeting
 logging
 datafile 'E:\oracle\oradata\orcl\MEETING.DBF'size 50m
 autoextend on
 next 50m maxsize 20480m
 extent management local;
 

5、创建用户并给用户分配表空间

 create user username identified by password  default tablespace tablespacename;

6、用户授权

 grant connect,resource,dba to username;