oracle常用语句
用户相关命令
1 --创建表空间 2 create tablespace mcd_ts datafile 'D:\app\mamp\oradata\orcl\mcd_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;