1,准备工作
查看dba_directories来查看数据库中已创建的目录
select * from dba_directories;
先使用这个目录:
DATA_PUMP_DIR,/home/oracle/app/admin/orcl/dpdump/
修改sys密码
alter user system identified by 12345;
2,导出源端数据
先搞点数据
create TABLESPACE adsda DATAFILE '/home/oracle/app/admin/orcl/dpdump/adsda.dbf' size 10M autoextend on maxsize 1G;
弄个用户给上点权限
create user user_adsda identified by 12345 default tablespace adsda ;
GRANT dba to user_adsda ;
grant