oracle-impdp&expdp总结

第二步：创建用户并赋权
-- Create the user
create user PROMOTION identified by "ChPromo123"
  default tablespace promotion
  temporary tablespace TEMP
  profile SDPUSER;

-- Grant/Revoke role privileges
grant connect to PROMOTION;
grant dba to PROMOTION;
grant exp_full_database to PROMOTION;
grant imp_full_database to PROMOTION;
grant resource to PROMOTION;

-- Grant/Revoke system privileges
grant alter any trigger to PROMOTION;
grant alter any type to PROMOTION;
grant create any directory to PROMOTION;
grant create any table to PROMOTION;
grant create any trigger to PROMOTION;
grant create any type to PROMOTION;
grant create any view to PROMOTION;
grant create job to PROMOTION;
grant create procedure to PROMOTION;
grant create sequence to PROMOTION;
grant create session to PROMOTION;
grant drop any table to PROMOTION;
grant dr