Oracle expdp and impdp command research, oracleexpdpimpdp
-- Create a remote data connection
Create database link DB_MZDB11 connect to YTMZTWO identified by YTMZTWO909 using 'mzdb11 ';
-- Create a local directory
Create directory db_mz as 'C :';
-- Authorize the user to read and write
Grant read, write on directory db_mz to YTMZTWO, YTMZ;
-- Authorized users can create dblink
Grant create database link to YTMZTWO, YTMZ;
Grant resource to YTMZTWO;
-- Export command
Expdp YTMZTWO/YTMZ2.2 schemas = YTMZTWO dumpfile = YTMZTWO. DMP directory = db_mz network_link = DB_MZDB11 logfile = log. log exclude = TABLE: \ "IN \ (\ 'pub _ ATTACHMENT \ ', \ 'pub _ SIGNSEAL \'\)\"
-- Add content to the configuration file
ORCL_rxxc =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 61.139.100.204) (PORT = 1522 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORACLE)
)
)
-- Direct data import command
Impdp YTMZTWO/YTMZ2.2 directory = db_mz NETWORK_LINK = DB_MZDB11 schemas = YTMZTWO logfile = log. log exclude = TABLE: \ "IN \ (\ 'pub _ ATTACHMENT \ ', \ 'pub _ SIGNSEAL \'\)\"
Job_name = my_job