当前位置：网站首页>impdp import data

impdp import data

2022-08-10 05:48:00 【The development of Lao zhang】

Import data to oracle using impdp

System: CentOS 6.6
Oracle: 10.2.0.5

Put the dmp file back.dmp into the /home/oracle/dump/ folder

To set up the directory in Oracle (using the sys user):
> create directory dumpdir as '/home/oracle/dump';
> grant read,write on directory dumpdir to myuser;

Command to view the directory status in the system:
> select * from dba_directories;

Execute the import command on the command line:
$ impdp myuser/myuserpass directory=dumpdir dumpfile=back.dmp

原网站

版权声明
本文为[The development of Lao zhang]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/222/202208100529087504.html