oracle schema export import using data pump

By ukmodak | March 31st 2024 10:32:28 AM | viewed 591 times
to export connect on toad and execute the following command
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

to import connect on toad and execute the following command

  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

bONEandALL
Visitor

Total : 27273

Today :9

Today Visit Country :

  • United States
  • Sweden
  • Singapore
  • Russia