Oracle DMP backup file Import (IMPDP) export (EXPDP) method

One IMPDP import

--Delete user if user already exists (can connect using Oracle's own sqlplus)
sql> Drop user user_name cascade
sql>/
sql> drop tablespace user_tablespace including contents and Datafiles
sql>/

--Create table space download
sql> CREATE tablespace user_tablespace datafile ' User_tablespace. DBF ' SIZE 200M autoextend on NEXT 50M MAXSIZE UNLIMITED PERMANENT DEFAULT STORAGE (INITIAL 64K minextents 1 MAXEXTENTS 2147 483645) MINIMUM EXTENT 64K LOGGING ONLINE
sql>/

--Create user
sql> CREATE USER user_name identified by User_password DEFAULT tablespace user_tablespace temporary tablespace TEMP Profile DEFAULT
sql>/
--Create user directory
sql> CREATE DIRECTORY directory_name as ' FilePath '
sql>/
--Example My_dir as ' d:/db_dir ' download
     
--Authorization for users
sql> GRANT CONNECT to user_name with ADMIN OPTION
sql>/
sql> GRANT DBA to user_name with ADMIN OPTION
sql>/
sql> GRANT UNLIMITED tablespace to user_name with ADMIN OPTION
sql>/
sql> GRANT Read, write on DIRECTORY directory_name to user_name
sql>/

--Perform import (Exit Sqlplus Execute import statement in cmd)
IMPDP user_name/[email protected]_name directory=directory_name dumpfile=user_name. DMP Schemas=user_name Logfile=user_name.log;
pause;

two EXPDP export download

EXPDP user_name/[email protected]_name directory=directory_name dumpfile=user_name. DMP Schemas=user_name Logfile=user_name.log;
pause;

Oracle DMP backup file Import (IMPDP) export (EXPDP) method