oracle schema export import using data pump

By ukmodak | June 6th 2022 12:23:03 PM | viewed 7 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;

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;

import will be start

bONEandALL
Visitor

Total : 4241

Today :37

Today Visit Country :

  • United States