Oracle创建表空间、用户常用语句

查询DBF文件位置

-- 查询数据库dbf文件所在位置 --
select * from dba_data_files;

查询DMP文件位置

-- 查询数据dmp文件所在位置 --
select * from dba_directories;

创建表空间

-- 创建表空间 --
create tablespace SYNCCLOUD
logging   
datafile '..\ORACLE\ORADATA\ORCL\SYNCCLOUD.DBF'
size 50m  
autoextend on  
next 50m 
MAXSIZE UNLIMITED 
extent management local;  

创建用户

-- 创建用户 Create the user --
create user SYNCCLOUD identified by "synccloud"
  default tablespace SYNCCLOUD
  temporary tablespace TEMP
  profile DEFAULT;

更新密码

-- 更新密码 --
alter user SYNCCLOUD identified by "synccloud";

创建表空间用户授权

-- 为用户授权 Grant/Revoke role privileges --
grant connect to SYNCCLOUD;
grant exp_full_database to SYNCCLOUD;
grant imp_full_database to SYNCCLOUD;
grant resource to SYNCCLOUD;

去除用户权限

-- 去除用户权限 --
grant dba to SYNCCLOUD;
revoke dba from SYNCCLOUD;