environment variable settings (performed in sqlplus) Create or replace directory filepath as ' D:\ORACLEBACKUP '; Backup script: EXPDP system/[email protected] Directory=filepath dumpfile=ubscorluser20150619.dat logfile=ubscorluser20150619.log schemas=ubscorluser restore: 1, Sqlplus System/[email protected]2.Delete the Aradmin user in the target database, drop users ubscorluser cascade;2.Create Aradmin user Ubscorluser identified by ubscorluser default tablespace SYSTEM temporary tablespace temp quota UNL Imited on System;3.Granting database permissions 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; environment variable settings (performed in sqlplus) Create or replace Directory filepath as ' D:\oracleData '; Close cmd Run window, re-execute CMD4, restore command: IMPDP system/[email protected] Directory=filepath Dumpfile=20150407server. DAT Logfile=20150407server.log Schemas=ubscorluser
Oracle Create command
