oracle export dmp file ：

Reference link ：https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-data-pump-export-utility.html#GUID-2BBE8F6C-6D58-4C99-8A49-ED4DA53BECD2

1. Switch oracle user

su - oracle

2. Sign in oracle service

sqlplus  /nolog

3. Connect the user

conn  / as sysdba

4. Connect to SQL The following commands can be used to create or query virtual paths , by dump Prepare for document storage

SQL> select * from dba_directories;
 Delete logical directory 
SQL> drop directory dumpdir;
SQL> create directory dumpdir as '/data/data2/bakfiles'; 

 to plsuser The user gives the operation authority in the specified directory ,  Best to system Wait for the administrator to give .
SQL> grant read, write on directory dumpdir to plsuser;   
 -- plsuser  by Oracle user 
 -- dumpdir  Export folder path for 
 

The most important point ： sign out oracle–sql—shell window

5. Export to dmp The folder of the file is assigned oracle User permissions , Be careful ：root Under the user Can't write in dmp file

[[email protected] ~]# chown -R oracle:oinstall /data/data2/ttt/ -- The directory where the backup file is located 
 

6. Switch oracle user , Execute export command ,

[[email protected] ~]$ expdp plsuser/pls111111 TABLES=policy_info  directory=dumpdir  dumpfile=beifentest.dmp content=data_only;

-- content=data_only  Export data only 
--content=metadata_only  Export only table structure 

According to the user guide
1)expdp system/manager schemas=scott DIRECTORY=dpdata dumpfile=expdp.dmp ;
2) Parallel processes parallel
expdp system/manager directory=dpdata dumpfile=scott3.dmp parallel=40 job_name=scott3
3) According to the table
expdp system/manager TABLES=emp,dept directory=dpdata dumpfile=expdp.dmp;
4) According to the query conditions
expdp system/manager directory=dpdata dumpfile=expdp.dmp Tables=emp query=‘WHERE deptno=20’;
5) Derive from table space
expdp system/manager DIRECTORY=dpdata DUMPFILE=tablespace.dmp TABLESPACES=temp,example;
6) Import the entire database
expdp system/manager DIRECTORY=dpdata DUMPFILE=full.dmp FULL=y;