12cdatapunp克隆用戶的分析

這篇文章給大家介紹12c data punp克隆用戶的分析，內(nèi)容非常詳細，感興趣的小伙伴們可以參考借鑒，希望對大家能有所幫助。

十載的樂安網(wǎng)站建設經(jīng)驗，針對設計、前端、開發(fā)、售后、文案、推廣等六對一服務，響應快，48小時及時工作處理。成都全網(wǎng)營銷的優(yōu)勢是能夠根據(jù)用戶設備顯示端的尺寸不同，自動調(diào)整樂安建站的顯示方式，使網(wǎng)站能夠適用不同顯示終端，在瀏覽器中調(diào)整網(wǎng)站的寬度，無論在任何一種瀏覽器上瀏覽網(wǎng)站，都能展現(xiàn)優(yōu)雅布局與設計，從而大程度地提升瀏覽體驗。創(chuàng)新互聯(lián)從事“樂安網(wǎng)站設計”,“樂安網(wǎng)站推廣”以來，每個客戶項目都認真落實執(zhí)行。

有時候生產(chǎn)環(huán)境會出現(xiàn)這樣的需求，將用戶及其對象和數(shù)據(jù)移動到其他數(shù)據(jù)庫測試，并且需要為該用戶重命名。這時候可以采用數(shù)據(jù)泵中remap_schema參數(shù)來處理。

數(shù)據(jù)泵目錄已經(jīng)創(chuàng)建好：dp_dir
數(shù)據(jù)泵用戶已經(jīng)創(chuàng)建好：dp/dp 權限為dba
測試用戶為hr

1. 導出schema為HR的所有內(nèi)容

[oracle@snow ~]$ expdp dp/dp directory=dp_dir dumpfile=hr.dmp logfile=hr.log schemas=hr

Export: Release 12.1.0.1.0 - Production on Mon Feb 9 15:21:47 2015

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Starting "DP"."SYS_EXPORT_SCHEMA_01":  dp/******** directory=dp_dir dumpfile=hr.dmp logfile=hr.log schemas=hr

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 448 KB

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE

Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/VIEW/VIEW

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/TRIGGER

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type SCHEMA_EXPORT/STATISTICS/MARKER

. . exported "HR"."COUNTRIES"                            6.437 KB      25 rows

. . exported "HR"."DEPARTMENTS"                          7.101 KB      27 rows

. . exported "HR"."EMPLOYEES"                            17.06 KB     107 rows

. . exported "HR"."JOBS"                                 7.085 KB      19 rows

. . exported "HR"."JOB_HISTORY"                          7.171 KB      10 rows

. . exported "HR"."LOCATIONS"                            8.414 KB      23 rows

. . exported "HR"."REGIONS"                              5.523 KB       4 rows

Master table "DP"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

******************************************************************************

Dump file set for DP.SYS_EXPORT_SCHEMA_01 is:

/home/oracle/hr.dmp

Job "DP"."SYS_EXPORT_SCHEMA_01" successfully completed at Mon Feb 9 15:22:17 2015 elapsed 0 00:00:30

導入schema為HR的所有內(nèi)容，并且重名為hr_new。 如果此時數(shù)據(jù)庫中沒有hr_new用戶，數(shù)據(jù)泵會自動創(chuàng)建。

[oracle@snow ~]$ impdp dp/dp directory=dp_dir dumpfile=hr.dmp remap_schema=hr:hr_new

Import: Release 12.1.0.1.0 - Production on Mon Feb 9 15:23:13 2015

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Master table "DP"."SYS_IMPORT_FULL_01" successfully loaded/unloaded

Starting "DP"."SYS_IMPORT_FULL_01":  dp/******** directory=dp_dir dumpfile=hr.dmp remap_schema=hr:hr_new

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

. . imported "HR_NEW"."COUNTRIES"                        6.437 KB      25 rows

. . imported "HR_NEW"."DEPARTMENTS"                      7.101 KB      27 rows

. . imported "HR_NEW"."EMPLOYEES"                        17.06 KB     107 rows

. . imported "HR_NEW"."JOBS"                             7.085 KB      19 rows

. . imported "HR_NEW"."JOB_HISTORY"                      7.171 KB      10 rows

. . imported "HR_NEW"."LOCATIONS"                        8.414 KB      23 rows

. . imported "HR_NEW"."REGIONS"                          5.523 KB       4 rows

Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE

Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/VIEW/VIEW

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/TRIGGER

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type SCHEMA_EXPORT/STATISTICS/MARKER

Job "DP"."SYS_IMPORT_FULL_01" successfully completed at Mon Feb 9 15:23:27 2015 elapsed 0 00:00:12

如果只需要元數(shù)據(jù)，并不需要數(shù)據(jù)可以使用content=metadata_only參數(shù)來實現(xiàn)

[oracle@snow ~]$ impdp dp/dp directory=dp_dir dumpfile=hr.dmp remap_schema=hr:hr_new_2 content=metadata_only

驗證一下克隆結(jié)果

[oracle@snow ~]$ sqlplus / as sysdba

SYS@ora12c >select username from dba_users where username like 'HR%';

USERNAME

--------------------------------------------------------------------------------

HR

HR_NEW

HR_NEW_2

使用最新克隆的hr_new_2并且只包含元數(shù)據(jù)的用戶登錄，密碼和克隆用戶相同也是hr

SYS@ora12c >conn hr_new_2/hr

Connected.

HR_NEW_2@ora12c >col tname for a20
HR_NEW_2@ora12c >select * from tab;

TNAME                TABTYPE  CLUSTERID
-------------------- ------- ----------
EMP_DETAILS_VIEW     VIEW
REGIONS              TABLE
LOCATIONS            TABLE
DEPARTMENTS          TABLE
JOBS                 TABLE
EMPLOYEES            TABLE
JOB_HISTORY          TABLE
COUNTRIES            TABLE

8 rows selected.

表都被創(chuàng)建出來了，但是表中沒有數(shù)據(jù)，和我們的預期一致！

HR_NEW_2@ora12c >select count(*) from employees;

COUNT(*)

----------

0

關于12c data punp克隆用戶的分析就分享到這里了，希望以上內(nèi)容可以對大家有一定的幫助，可以學到更多知識。如果覺得文章不錯，可以把它分享出去讓更多的人看到。

文章題目：12cdatapunp克隆用戶的分析
分享路徑：http://www.jbt999.com/article32/ihsdsc.html

成都網(wǎng)站建設公司_創(chuàng)新互聯(lián)，為您提供自適應網(wǎng)站、微信公眾號、網(wǎng)站設計、面包屑導航、網(wǎng)站設計公司、網(wǎng)站維護

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：[email protected]。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)