-- 清空表空间数据
drop tablespace XXX including contents and datafiles;
drop user XXX cascade;
-- 创建表空间及用户
CREATE TABLESPACE XXX DATAFILE 'D:\app\tiger\oradata\orcl\XXX.dbf' SIZE 100M;
-- 创建用户
CREATE USER XXX IDENTIFIED BY XXX DEFAULT TABLESPACE XXX TEMPORARY TABLESPACE TEMP;
-- 赋予权限
GRANT CONNECT TO XXX;
GRANT DBA TO XXX;
GRANT resource TO XXX;
drop tablespace XXX including contents and datafiles;
drop user XXX cascade;
-- 创建表空间及用户
CREATE TABLESPACE XXX DATAFILE 'D:\app\tiger\oradata\orcl\XXX.dbf' SIZE 100M;
-- 创建用户
CREATE USER XXX IDENTIFIED BY XXX DEFAULT TABLESPACE XXX TEMPORARY TABLESPACE TEMP;
-- 赋予权限
GRANT CONNECT TO XXX;
GRANT DBA TO XXX;
GRANT resource TO XXX;
oracle 11g 中,PLSQL 客户端和数据库的编码要一致。