1. <td id="kbyxm"><ruby id="kbyxm"></ruby></td>
    2. <acronym id="kbyxm"></acronym>
      <pre id="kbyxm"></pre>
        <track id="kbyxm"><strike id="kbyxm"></strike></track>
          <tr id="kbyxm"></tr>

        1. <table id="kbyxm"></table>
        2. <acronym id="kbyxm"></acronym>

          ORCL 導入導出(個人筆記版)

           

          sqlplus / as sysdba 登錄數據庫

          windows服務器導出:
          數據庫版本
          11.2.0.1.0

          創建文件目錄
          create directory DATA_PUMP_DIR as 'D:\download_database';

          授權寫入讀取
          Grant read,write on directory DATA_PUMP_DIR to phis26;

          導出數據庫到 DATA_PUMP_DIR
          expdp phis26/phis26@bsoft directory=DATA_PUMP_DIR dumpfile=phis26.dmp schemas=phis26 logfile=phis26.log;

          本地數據庫導入:
          創建表空間
          CREATE TABLESPACE PHIS26 DATAFILE 'D:\database\PHIS26.ora' SIZE 10M AUTOEXTEND ON NEXT 10M;
          創建用戶
          create user phis26 identified by phis26 default tablespace phis26;
          授權
          grant connect to phis26;
          grant resource to phis26;
          grant dba to phis26;

          創建文件目錄
          create directory dir_me as 'D:\databasebackup';
          grant read,write on directory dir_me to phis26;

          普通導入
          impdp phis26/phis26@orcl directory = dir_me dumpfile = 'PHIS26.DMP' logfile = 'phis.log' full= y;

          導入從 A用戶到B用戶
          前提:(用戶和表空間B要存在)
          remap_schema=A:B
          remap_tablespace=A:B
          導入解釋:impdp 用戶/密碼@IP:1521/orcl directory=目錄空間 dumpfile=導入的數據文件 remap_schema=原用戶:現在用戶 remap_tablespace=原表空間:現在表空間 logfile=生成的日志文件 full=y(將整個數據庫全部導入);
          impdp phis26/phis26@orcl directory = dir_me dumpfile = 'PHIS26.DMP' remap_schema=phis26:phis26 remap_tablespace=BSPHIS263:PHIS26 logfile = 'phis.log' full= y;


          已有 0 條評論

            歡迎您,新朋友,感謝參與互動!
            2020日本三级黄色电影_三级黄色电影在线观看_亚洲bt色图噜一噜色视频_国产av在线网站
            1. <td id="kbyxm"><ruby id="kbyxm"></ruby></td>
            2. <acronym id="kbyxm"></acronym>
              <pre id="kbyxm"></pre>
                <track id="kbyxm"><strike id="kbyxm"></strike></track>
                  <tr id="kbyxm"></tr>

                1. <table id="kbyxm"></table>
                2. <acronym id="kbyxm"></acronym>