CREATE OR REPLACE DIRECTORY EXP_DIR AS 'E:\DATA_PUMP_DIR\'; GRANT READ, WRITE ON DIRECTORY EXP_DIR TO desco_schema;
from start->cmd and past the following line and enter
expdp system/system@db11gtns schemas=icab directory=EXP_DIR dumpfile=200514db19.dmp logfile=200514db19.log; or expdp erp/erp@orcl schemas=dalerp directory=DATA_PUMP_DIR dumpfile=DALERP_TESCO_ONLINE_6_8_2022.dmp logfile=DALERP_TESCO_ONLINE_6_8_2022.log;
if want user and password then enter sys user and sys pass and export will start
CREATE USER icab IDENTIFIED BY icab DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; GRANT DBA TO icab; GRANT RESOURCE TO icab; GRANT CONNECT TO icab; ALTER USER icab DEFAULT ROLE ALL; GRANT UNLIMITED TABLESPACE TO icab; CREATE OR REPLACE DIRECTORY EXP_DIR AS 'E:\DATA_PUMP_DIR\'; GRANT READ, WRITE ON DIRECTORY EXP_DIR TO icab;
from start->cmd and past the following line and enter
impdp system/system@db11gtns schemas=icab directory=EXP_DIR dumpfile=200514db19.dmp logfile=200514db19.log; or impdp dalpdf/dalpdf@orcl directory=DATA_PUMP_DIR dumpfile=DALPDFPRINT_TESCO_ONLINE_8_8_2022.DMP logfile=DALPDFPRINT_TESCO_ONLINE_8_8_2022.log; or impdp uktest12345/uktest12345@commonpdbs[target schema info] schemas=uktest[source schema] directory=DATA_PUMP_DIR dumpfile=uktest_17_8_2022.dmp REMAP_SCHEMA=uktest[source schema]:uktest12345[target schema] logfile=uktest_17_8_2022.log; // no need to match schema password
import will be start
Total : 27273
Today :9
Today Visit Country :