impdp/expdp导入导出库

最新推荐文章于 2024-07-02 17:08:54 发布

CZ_YZ

最新推荐文章于 2024-07-02 17:08:54 发布

阅读量363

点赞数 1

分类专栏： Oracle

本文链接：https://blog.csdn.net/CZ_YZ/article/details/78201987

版权

Oracle 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

导出数据库

删除用户 drop user zwzhang cascade;
创建指定导出路径；
create or replace directory dmpdir as '/oraexport/dmpdir/';

给xiaoyao用户赋予权限
grant read,write on directory dmpdir to xiaoyao;
导出数据库
expdp xiaoyao/xiaoyao directory=dmpdir dumpfile=expxiaoyao.dmp logfile=exp.log schemas=xiaoyao

导入数据库：

创建用户 impXiaoyao
create user impXiaoyao identified by impXiaoyao default tablespace itreasury temporary tablespace temp account unlock;

给impXiaoyao赋予权限
grant connect, resource, dba to impXiaoyao;

创建导入指定路径
create or replace directory dmpdir as '/home/';
赋予权限
grant read,write on directory dmpdir to impXiaoyao;

导入数据
impdp impXiaoyao/impXiaoyao remap_schema=xiaoyao:impXiaoyao directory=dmpdir dumpfile=expxiaoyao.dmp table_exists_action=replace logfile=xiaoyao_impdp_replace.log status=30

空表也导入

impdp impXiaoyao/impXiaoyao remap_schema=gdfcl:impXiaoyao directory=dmpdir dumpfile=expxiaoyao.dmp table_exists_action=replace logfile=xiaoyao_impdp_replace.log transform=segment_attributes:n status=30

导入单张表：
impdp impXiaoyao/impXiaoyao remap_schema=xiaoyao:impXiaoyao directory=dmpdir dumpfile=expxiaoyao.dmp tables=xiaoyao.xxx table_exists_action=replace logfile=xiaoyao_impdp_replace.log