Shulou(Shulou.com)05/31 Report--

This article is about how to export expdp. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

First, create an expdp backup directory

Create directory home as'/ home/oracle/backup'

Second, give read and write permissions to the backup directory

Grant read,write on directory home to scott

3. Export data

1. Export all schemes except SYS, ORDSYS and MDSYS. This kind of export is also called full export mode.

Expdp scott/oracle cluster=n compression=all full=y parallel=2 nologfile=y dumpfile=EX%U.dmp directory=home reuse_dumpfiles=y

2. Use the tablespaces parameter to export all objects in users and example tablespaces

Expdp scott/oracle cluster=n tablespace=users,example parallel=2 nologfile=y dumpfile=EX%U.dmp directory=home reuse_dumpfiles=y

3. Use schemas parameter to export hr and oe schemes.

Expdp scott/oracle cluster=n schemas=hr,oe parallel=2 nologfile=y dumpfile=EX%U.dmp directory=home reuse_dumpfiles=y

4. Use tables parameter to export dept and emp

Expdp scott/oracle tables=scott.dept,scott.emp parallel=2 nologfile=y dumpfile=EX%U directory=home reuse_dumpfiles=y

5. Back up the table with exclusion parameters

DEPT tables are not backed up, other tables are backed up

Expdp scott/oracle exclude=table:\ "IN\ (\ 'DEPT\'\)\" parallel=2 nologfile=y dumpfile=EX%U directory=home reuse_dumpfiles=y

Exclude multiple tables

Expdp scott/oracle exclude=table:\ "IN\ (\ 'DEPT\',\ 'EMP\')\" parallel=2 nologfile=y dumpfile=EX%U directory=home reuse_dumpfiles=y

6. Exclusion solution backup

Expdp scott/oracle full=y exclude=schema:\ "IN\ (\'OE\',\'HR\')\" parallel=2 nologfile=y dumpfile=EX%U directory=home reuse_dumpfiles=y

Thank you for reading! This is the end of the article on "how to Export expdp". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.