Oracle multiple tables Export and import __oracle

Sometimes we need to migrate the data of the database, but some data will not let the migration in the case of partial table export Import.

----Data export
--Create a directory to put DMP files
Mkdir-p/backup/oracle/dmp

--Assign value to Oracle users
Chown-r Oracle:oinstall/backup

--Log in to the database with Super admin
Sqlplus/as Sysdba;

Create directory Dmp_file as '/backup/oracle/dmp ';
Grant Read,write on directory Dmp_file to the user who needs to export the data;
Exit

EXPDP User/password Directory=dmp_file dumpfile=xx.dmp logfile=xx.log tables= (table 1, table 2);

----Import

--You need to delete the imported tables before importing them.

drop table 1;
drop table 2;

IMPDP system/password Directory=dmp_file dumpfile=xx.dmp logfile=xximport.log

At this point, the import was successful. Data pump commands must be supported on the database server side.