oracle 创建命令

删除目标数据库中的ARADMIN用户drop user UBSCORLUSER cascade;2. 创建ARADMIN用户create user UBSCORLUSER identified by UBSCORLUSER default tablespace SYSTEM temporary tablespace temp quota unlimited on system;3. 赋予数据库权限grant alter session,create cluster,create database link,create sequence,create session,create synonym,create table,create view,create procedure,create trigger,query rewrite to UBSCORLUSER;环境变量设置(在Sqlplus中执行)create or replace directory filepath as ‘D:oracleData‘;关闭cmd运行窗口，重新执行cmd4,还原命令：impdp system/123456@orcl directory=filepath dumpfile=20150407server.DAT logfile=20150407server.log schemas=UBSCORLUSER

oracle 创建命令

标签：

本文系统来源：http://www.cnblogs.com/dullbaby/p/4613476.html

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！