可在命令行直接执行。

删除EMS用户命令:
 
sqlplus /nolog
SQL>conn / as sysdba;
SQL>drop user EMS cascade;

创建用户ＥＭＳ：

(创建用户EMS,设置密码为password，默认表空间为OPEN_DATA,零时空间为OPEN_TEMP，后面的GRANT是为用户赋予相应的权限。)

CREATE USER "EMS"  PROFILE "DEFAULT"  IDENTIFIED BY "password" DEFAULT TABLESPACE "OPEN_DATA"
    TEMPORARY TABLESPACE "OPEN_TEMP" ACCOUNT UNLOCK;
GRANT UNLIMITED TABLESPACE TO "EMS";
GRANT "CONNECT" TO "EMS";
GRANT "DBA" TO "EMS";
GRANT "EXP_FULL_DATABASE" TO "EMS";
GRANT "IMP_FULL_DATABASE" TO "EMS";