Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > Oracle学习笔记：exp数据导出工具用法

Oracle学习笔记：exp数据导出工具用法

WBOY
Release： 2016-06-07 17:05:55
Original
916 people have browsed it

首先通过UE等编辑软件打开dmp文件或者在Linux下执行如下然后察看第二、三字节。如果dmp文件很大，比如有2G以上(这也是最常见的情

1、导出工具的参数详解

2、常用导出命令

完全模式导出（整个数据库）

  • 用户模式导出（导出用户ing下面的所有对象）

  • exp system/oracle owner=ing file=demo2.dmp log=demo2.log  

    • 表模式导出（导出用户ing下的dept表）

  • exp system/oracle tables=ing.dept file=demo3.dmp log=demo3.log  

    • 带where条件的导出（导出用户ing下dept表的前两行）

  • 模糊导出（导出用户ing下以de开头的表）

  • exp system/oracle@orcl tables=ing.de% file=demo5.dmp log=demo5.log  

    • 3、通过dmp文件察看Oracle字符集
    首先通过UE等编辑软件打开dmp文件或者在Linux下执行如下然后察看第二、三字节。如果dmp文件很大，比如有2G以上(这也是最常见的情况)，用文本编辑器打开很慢或者完全打不开，可以用以下命令(在linux主机上)：

  • 0345  

    •  

    4、导出权限问题

    如果是普通用户导出、导入，，需要授予权限

    5、字符集问题

    在导出的时候最还设置客户端的字符集和数据库一样。

  • [oracle@linux exp]$ echo $NLS_LANG  
  • SIMPLIFIED CHINESE_CHINA.ZHS16GBK  

    • linux

    Related labels：
    Oracle教程 Oracle学习笔记：exp数据导出工具用
    source：php.cn
    Previous article：Oracle笔记：dbca出错C [libnnz11.so+0x3c3a8] Next article：SOLARIS下RAC中的vip无法正常启动的解决办法
    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
    Latest Articles by Author
    Latest Issues
    Regular expression filter for MERN stack search boxes and checkboxes I'm trying to understand how the MERN stack works together by learning by doing, and I'm f...
    From 2024-04-06 14:53:12
    0
    1
    425
    How to render data through DOM instead of through table I have a question about an application I'm creating, I'm using an Oracle database and I'm ...
    From 2024-04-04 18:17:27
    0
    1
    3567
    Prestashop installation issue: Unable to install custom module I am new to Prestashop module development. I'm trying to build Amy's first prestashop modu...
    From 2024-04-03 19:24:44
    0
    1
    402
    PHP Tutorial: How to upload text and images to Linkedin using PHP? I try to upload text, images and links using LinkedinsRestAPI (https://learn.microsoft.com...
    From 2024-04-03 18:42:29
    0
    1
    420
    Unable to receive information from my mySQL database despite having seen tutorials doing the exact same thing So I'm trying to make a program that reads and writes to a MySQL database, which led me to...
    From 2024-04-03 14:46:04
    0
    1
    298
    Related Topics
    More>
    Popular Recommendations
    Popular Tutorials
    More>
    Related Tutorials
    Popular Recommendations
    Latest courses
    Latest Downloads
    More>
    Web Effects
    Website Source Code
    Website Materials
    Front End Template