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 创建命令

标签：