Export / Import dump in Oracle using expdb/impdb

oracle_dump.sql

--
-- EXPORT
--

-- Checkfolders to export :
select OWNER, DIRECTORY_NAME,DIRECTORY_PATH from DBA_DIRECTORIES order by OWNER, DIRECTORY_NAME;
 
-- If need new one :
CREATE DIRECTORY DP_DIR as '/backup/folder' ;
-- Create it also on OS then :
GRANT read,write ON DIRECTORY DP_DIR TO system ;
        
-- export the dump:        
expdp system/manager@MYUSER schemas=MYSCHEMA directory=EXP_DIR dumpfile=dump.dmp

-- 
-- IMPORT
--

-- Create tablespaces
SELECT file_name, tablespace_name, ROUND(bytes/1024000) MB
FROM dba_data_files
ORDER BY 1;

-- Create tablespaces
CREATE TABLESPACE DATATAB
DATAFILE '/data/id/db1/data_tab_01.dbf' SIZE 128M REUSE AUTOEXTEND ON NEXT 128M MAXSIZE 4G; 
CREATE TABLESPACE DATAIDX
DATAFILE '/data/id/db1/data_idx_01.dbf' SIZE 128M REUSE AUTOEXTEND ON NEXT 128M MAXSIZE 4G; 


CREATE USER MYUSER
IDENTIFIED BY MYUSER DEFAULT TABLESPACE DATATAB
TEMPORARY TABLESPACE TEMP;
GRANT CONNECT TO MYUSER;
GRANT EXECUTE_CATALOG_ROLE TO MYUSER;
GRANT RESOURCE TO MYUSER;
ALTER USER MYUSER DEFAULT ROLE ALL;
ALTER USER MYUSER QUOTA UNLIMITED ON DATAIDX;
ALTER USER MYUSER QUOTA UNLIMITED ON DATATAB;

-- import dump in another schema
impdp \'\/ as sysdba\' schemas=MYSCHEMA directory=data_pump_dir dumpfile=dump.dmp logfile=import.log REMAP_SCHEMA=USER:MYUSER