oracle 建立命令

標籤：

環境變數設定(在Sqlplus中執行)create or replace directory filepath as ‘D:\ORACLEBACKUP‘;備份指令碼：expdp system/[email protected] directory=filepath dumpfile=UBSCORLUSER20150619.dat logfile=UBSCORLUSER20150619.log schemas=UBSCORLUSER還原:1,sqlplus system/[email protected]2.刪除目標資料庫中的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/[email protected] directory=filepath dumpfile=20150407server.DAT logfile=20150407server.log schemas=UBSCORLUSER

oracle 建立命令