oracle创建一个使用expdp备份的用户
创建备份用户:backup/back_123
--创建表空间
CREATE TABLESPACE BACKUP_DATA DATAFILE
'+RACASMGROUP/rac/datafile/backup_data1.ora' SIZE 4096M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;
--创建用户
CREATE USER backup IDENTIFIED BY back_123
ACCOUNT UNLOCK
DEFAULT TABLESPACE BACKUP_DATA
TEMPORARY TABLESPACE TEMP;
--授权
GRANT CONNECT,RESOURCE TO backup;
--创建directory
create directory DUMP_BACKUP1 as '/oracle/backup/backup/1';
create directory DUMP_BACKUP2 as '/oracle/backup/backup/2';
create directory DUMP_BACKUP3 as '/oracle/backup/backup/3';
create directory DUMP_BACKUP4 as '/oracle/backup/backup/4';
create directory DUMP_BACKUP5 as '/oracle/backup/backup/5';
create directory DUMP_BAC