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

Source: Internet
Author: User
Tags create directory sqlplus

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.