oracle常用语句

用户相关命令
 1 --创建表空间
 2 create tablespace mcd_ts datafile 'D:appmamporadataorclmcd_data.dbf' size 20480M;
 3 
 4 --删除表空间
 5 DROP TABLESPACE mcd_ts INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
 6 
 7 --创建用户
 8 create user MCD_GZ identified by mcd_gz default tablespace mcd_ts;
 9 
10 --表示把 connect，resource权限授予MCD_GZ用户
11 grant connect，resource to MCD_GZ;
12 
13 --表示把 dba权限授予给testone用户 ,授权完成
14 grant dba to MCD_GZ; 
15 
16 -- 修改密码
17 alter user XXXUSER identified by xxpass;
18 
19 -- 解锁账号
20 alter user XXXUSER identified by oracle account unlock;