Windwo环境下在Oracle表空间、账号新建

现记录在Window下新建Oracle11g表空间、账号的SQL,以方便日后使用

--删除现有表空间

DROP TABLESPACE NJDT_YY_DEV_V2
INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;

--新建表空间

create tablespace NJDT_YY_DEV_V2
datafile 'F:/app/TyUsers/oradata/orcl/NJDT_YY_DEV_V2.dbf' size 100m autoextend on next 50m maxsize 10240m extent management local;

--新建账号
create user NJDT_YY_DEV_V2
identified by 123456 account unlock default tablespace NJDT_YY_DEV_V2
TEMPORARY TABLESPACE TEMP;

--账号授权

grant connect,resource to NJDT_YY_DEV_V2;

--备份还原授权

grant read,write on directory DATA_PUMP_DIR to NJDT_YY_DEV_V2;
grant IMP_FULL_DATABASE to NJDT_YY_DEV_V2;