Home > Database > Mysql Tutorial > expdp 导出简单笔记

expdp 导出简单笔记

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-07 17:17:18
Original
1042 people have browsed it

expdp 导出简单笔记1、要创建oracle可访问的目录必须赋予oracle:oinstall的权限[root@oracle/]# chown -R oracle:oinstall /data

expdp 导出简单笔记

1、要创建Oracle可访问的目录必须赋予oracle:oinstall的权限
[root@oracle/]# chown -R oracle:oinstall /data1

2、切换到oracle用户
[root@oracle/]# su - oracle

3、创建expdp目录
[oracle@oracle/]$ cd /data1
[oracle@oracle data1]$ mkdir expdp
[oracle@oracle data1]$ cd expdp/
[oracle@oracle expdp]$ pwd
/data1/expdp

4、关联目录

SQL> create directory expdp as '/data1/expdp';

目录已创建。

5、赋予数据库用户mam40可直接读写的权限
SQL> grant read,write on directory expdp to mam40;

授权成功。

6、通过mam40用户导出数据库mam40对象的数据,将其存放到/data1/expdp 目录下。(注意:切换到操作系统命令行执行)
[oracle@oracle expdp]$ expdp mam40/password@wlw schemas=mam40 dumpfile=expdp001.dmp DIRECTORY=expdp version=10.2.0.5;

linux

Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template