数据棒导入导出
创建目录
create directory tab_test as '/home/oracle/labs/extab1'
grant read on directory tab_test to hr
grant write on directory tab_test to hr;
创建表
create table emp as select * from employees;
expdp hr/hr directory=tab_test dumpfile=emp.dmp tables=emp;
impdp hr/hr directory=:dir_expdp dumpfile=emp.dmp remap_tabel=emp:emp1
错误：
创建目录
create directory "tab_test" as '/home/oracle/labs/extab1'
grant read on directory "tab_test" to hr
grant write on directory "tab_test" to hr
创建表
create table emp as select * from employees;
expdp hr/hr directory=tab_test dumpfile=emp.dmp tables=emp
-------------------------------------------
正确：
创建目录
create directory tab_test as '/home/oracle/labs/extab1'
grant read on directory tab_test to hr
grant write on directory tab_test to hr;
创建表
create table emp as select * from employees;
expdp hr/hr directory=tab_test dumpfile=emp.dmp tables=emp;
create directory tab_test as '/home/oracle/labs/extab1'
grant read on directory tab_test to hr
grant write on directory tab_test to hr;
创建表
create table emp as select * from employees;
expdp hr/hr directory=tab_test dumpfile=emp.dmp tables=emp;
impdp hr/hr directory=:dir_expdp dumpfile=emp.dmp remap_tabel=emp:emp1
错误：
创建目录
create directory "tab_test" as '/home/oracle/labs/extab1'
grant read on directory "tab_test" to hr
grant write on directory "tab_test" to hr
创建表
create table emp as select * from employees;
expdp hr/hr directory=tab_test dumpfile=emp.dmp tables=emp
-------------------------------------------
正确：
创建目录
create directory tab_test as '/home/oracle/labs/extab1'
grant read on directory tab_test to hr
grant write on directory tab_test to hr;
创建表
create table emp as select * from employees;
expdp hr/hr directory=tab_test dumpfile=emp.dmp tables=emp;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28889722/viewspace-1244292/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
文件系统下备份表空间
下一篇：
恢复目录相关
请登录后发表评论
登录
全部评论
