Oracle Database backup instructions (to be continued)

# Oracle Database backup instructions are exported in EXPDP mode

1. Log in to the database using an administrator

2. Querying the logical directory

   select * from dba_directories;

3. Creating a logical Directory

   create directory [name] as [url];

   Cases

   create directory mulu as ‘d:\oraclebak‘;

4. Empowering

   grant read,write on directory [name] to [user];

   Cases

   grant read,write on directory mulu to tuser;

5. Export a database by user

   expdp [数据源] dumpfile=[导出文件名称] directory=[虚拟目录名称];

   Cases

   expdp tuser/[email protected] dumpfile=expdp.dmp directory=mulu;

Oracle Database backup instructions (to be continued)