Qiita Teams that are logged in
You are not logged in to any team

Log in to Qiita Team
Community
OrganizationAdvent CalendarQiitadon (β)
Service
Qiita JobsQiita ZineQiita Blog
4
Help us understand the problem. What is going on with this article?
@sugimount

[Oracle Cloud] Data Pump を使用してデータ移行をしてみた

More than 1 year has passed since last update.

はじめに

Oracle DB には、様々なデータ移行方法が存在しています。
今回は、Data Pump という機能を使用したデータ移行方法を確認していきます。

その他のデータ移行方法については、以下の OCI の Document が参考となります。
https://docs.oracle.com/cd/E97706_01/Content/Database/Tasks/migrating.htm

事前準備

Oracle DB 環境の作成

Oracle Cloud Infrastructure 上で、移行元・移行先・Client の3環境を準備します。
Client 環境は準備しなくても、移行元・移行先の OS 内で直接 Data Pump を使用すれば問題ないです。今回 Client 環境を準備する理由は、Oracle DB の外部から Data Pump を実行した時の挙動を確認したいためです。

Oracle DB のバージョンが 12 以降の場合は、Oracle Instant Client の関連パッケージの中で、Data Pump, Import/Export が含まれています。
ただ、11以前のバージョンの場合は、以下のURL でアナウンスされている通り、Oracle Full Client の導入が必要です。そのため、OCI DBCS を使用して、Client 環境を作成しています。
https://orablogs-jp.blogspot.com/2017/08/oracle-instant-client-122-now-has.html

また、Client 環境のバージョンは注意が必要です。以下のURLには、Client と 移行元・移行先のバージョンのサポートマトリックス表が記載されています。(My Oracle Support アカウントが必要)
この表を参照して、どのようなバージョンがサポートされているかを確認することが大事です。
https://support.oracle.com/knowledge/Enterprise%20Management/2364786_1.html

ハマった例を挙げると、2019年11月で最新の Data Pump Client バージョン 19 から、Oracle DB Server 11.2.0.4 へ接続は、エラーで接続が出来ませんでした。

移行元DB (OCI DBCS)

  • 名前 : sourcedb
  • Edition : Standard Edition
  • Version : 11.2.0.4
  • Password : mIfoO8_fai12#-gai897fao

移行先DB (OCI DBCS)

  • 名前 : destidb
  • Edition : Standard Edition
  • Version : 11.2.0.4
  • Password : mIfoO8_fai12#-gai897fao

Client (OCI DBCS) : 必須ではない

  • 名前 : client
  • Edition : Standard Edition
  • Version : 11.2.0.4
  • Password : mIfoO8_fai12#-gai897fao

テストデータの生成

移行元で、テストデータを生成します。
テストデータを生成するために、Oracle DB へ接続を行う必要があるのですが、自分の場合は、Visual Studio Code の Oracle DB 拡張機能 から OCI の DBCS へ接続を行っています。接続方法は以下をご覧ください。
https://qiita.com/sugimount/items/a71f470e9dc59fcd4957

まず、SUGI ユーザー・スキーマの作成して、テストデータを生成出来るように権限などを設定します。

CREATE USER sugi IDENTIFIED BY mIfoO8_fai12#gai897faosugi;
GRANT CONNECT, RESOURCE TO sugi;
ALTER USER sugi quota unlimited on USERS;

sugi ユーザーでログインして、テストデータ用の Table を作成します

CREATE TABLE EXAMPLES (
  ID INTEGER
 ,LABEL     VARCHAR2(100)  NOT NULL
 ,SCORE     NUMBER         NOT NULL
 ,RATE      NUMBER         NOT NULL
 ,BIRTHDAY  DATE           NOT NULL
 ,PRIMARY KEY (ID)
);

Sample データを生成します。50万行のデータが生成されます。

INSERT INTO EXAMPLES
    SELECT 
      ROWNUM
     ,DBMS_RANDOM.STRING('A', 100)
     ,FLOOR(DBMS_RANDOM.VALUE(1, 100000))
     ,DBMS_RANDOM.VALUE()
     ,TO_DATE('19000101','YYYYMMDD') + FLOOR(DBMS_RANDOM.VALUE(1, 365 * 120))
    FROM
      (select 0 from all_catalog where rownum <= 1000)
     ,(select 0 from all_catalog where rownum <= 500)
;

SELECT で確認します。

SELECT * FROM EXAMPLES WHERE ROWNUM <= 10;

memo 全データ削除

DELETE FROM EXAMPLES;

EXAMPLES2テーブルも作成し、同様にテストデータを入れます。

CREATE TABLE EXAMPLES2 (
  ID INTEGER
 ,LABEL     VARCHAR2(100)  NOT NULL
 ,SCORE     NUMBER         NOT NULL
 ,RATE      NUMBER         NOT NULL
 ,BIRTHDAY  DATE           NOT NULL
 ,PRIMARY KEY (ID)
);
INSERT INTO EXAMPLES2
    SELECT 
      ROWNUM
     ,DBMS_RANDOM.STRING('A', 100)
     ,FLOOR(DBMS_RANDOM.VALUE(1, 100000))
     ,DBMS_RANDOM.VALUE()
     ,TO_DATE('19000101','YYYYMMDD') + FLOOR(DBMS_RANDOM.VALUE(1, 365 * 120))
    FROM
      (select 0 from all_catalog where rownum <= 1000)
     ,(select 0 from all_catalog where rownum <= 500)
;

Clientの設定(11.2.0.4.0)

各種ツールの確認

OCI の DBCS で作成した、Client 環境に接続して、各種ツールのバージョンを確認します。
まず、SSHでログインして、oracle ユーザーへスイッチします

> ssh opc@10.0.0.61
[opc@client ~]$  
[opc@client ~]$ sudo su - oracle 
Last login: Sat Nov 23 11:09:53 UTC 2019 
[oracle@client ~]$

Data Pump : 11.2.0.4.0

[oracle@client ~]$ expdp HELP=Y   

Export: Release 11.2.0.4.0 - Production on Sat Nov 23 11:15:38 2019

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


The Data Pump export utility provides a mechanism for transferring data objects
between Oracle databases. The utility is invoked with the following command:

   Example: expdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp

You can control how Export runs by entering the 'expdp' command followed
by various parameters. To specify parameters, you use keywords:

   Format:  expdp KEYWORD=value or KEYWORD=(value1,value2,...,valueN)
   Example: expdp scott/tiger DUMPFILE=scott.dmp DIRECTORY=dmpdir SCHEMAS=scott
               or TABLES=(T1:P1,T1:P2), if T1 is partitioned table

USERID must be the first parameter on the command line.

略

従来の Export/Import にあたる、expコマンド : 11.2.0.4.0

[oracle@client ~]$ exp HELP=Y  

Export: Release 11.2.0.4.0 - Production on Sat Nov 23 11:17:37 2019

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

略

sqlplus : 11.2.0.4.0

[oracle@client ~]$ sqlplus -H 

SQL*Plus: Release 11.2.0.4.0 Production

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Use SQL*Plus to execute SQL, PL/SQL and SQL*Plus statements.

略

tnsnames.ora の作成

OCI で作成した、DBCS の詳細画面から、DB Connection を選択します

1574480414519.png

Copy を押して、接続に必要な情報をコピーします

1574480475922.png

この Database Connection の情報を、移行元(Source) と移行先(Destination) の両方ともからコピーします

Client の以下のパスに tnsnames.ora ファイルを作成します。パスは Oracle Client のバージョンやインストール方法よって適宜変更します。

vim /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/tnsnames.ora
sourcedb=
(DESCRIPTION=
  (CONNECT_TIMEOUT=5)
  (TRANSPORT_CONNECT_TIMEOUT=3)
  (RETRY_COUNT=3)
  (ADDRESS_LIST=
    (LOAD_BALANCE=on)
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=10.0.100.3)
      (PORT=1521)
    )
  )
  (CONNECT_DATA=
    (SERVICE_NAME=DB1112_nrt1kv.privsubnet01.vcn.oraclevcn.com)
  )
)

destidb=
(DESCRIPTION=
  (CONNECT_TIMEOUT=5)
  (TRANSPORT_CONNECT_TIMEOUT=3)
  (RETRY_COUNT=3)
  (ADDRESS_LIST=
    (LOAD_BALANCE=on)
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=10.0.100.4)
      (PORT=1521)
    )
  )
  (CONNECT_DATA=
    (SERVICE_NAME=destidb_nrt1pn.privsubnet01.vcn.oraclevcn.com)
  )
)

Data Pump で Export

Dump File 出力先の指定

移行元の OCI DBCS 上で Dump File 出力先の Directory を作成します

mkdir /tmp/datapump
chmod 777 /tmp/datapump

client から sqlplus で接続を行います

sqlplus sys/mIfoO8_fai12#-gai897fao@sourcedb AS SYSDBA

接続例

[oracle@client admin]$ sqlplus sys/mIfoO8_fai12#-gai897fao@sourcedb AS SYSDBA 

SQL*Plus: Release 11.2.0.4.0 Production on Sat Nov 23 11:22:49 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL>

現時点では、Directory Object を作成していないため、何も存在しないことを確認します

select directory_name, directory_path from dba_directories where directory_name='DPUMP_DIR';

実行例
no rows selected と表示されればOKです

SQL> select directory_name, directory_path from dba_directories where directory_name='DPUMP_DIR'; 

no rows selected

SQL> 

Data Pump の出力先ディレクトリを Directory オブジェクトとして作成します

create directory dpump_dir as '/tmp/datapump';

実行例

SQL> create directory dpump_dir as '/tmp/datapump'; 

Directory created.

SQL> 

確認します

select directory_name, directory_path from dba_directories where directory_name='DPUMP_DIR';

実行例
先ほどは空白でしたが、定義した内容が取得できました

SQL> select directory_name, directory_path from dba_directories where directory_name='DPUMP_DIR'; 

DIRECTORY_NAME
------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
DPUMP_DIR
/tmp/datapump

memo 削除コマンド drop

drop directory dpump_dir;

Dump File 出力先の Directory へ権限の付与を行います

grant read, write on directory dpump_dir to system;

実行例

SQL> grant read, write on directory dpump_dir to system; 

Grant succeeded.

SQL> 

sugi のスキーマに存在するすべての Object 一覧を表示。データ移行元と先で、全てのオブジェクトが移行されたかを確認するために出力

select object_name, object_type from dba_objects where owner='SUGI' order by object_name;

実行例

  • TABLE : EXAMPLES EXAMPLES2
  • INDEX : SYS_c005728 SYS_c005781
SQL> select object_name, object_type from dba_objects where owner='SUGI' order by object_name; 

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
EXAMPLES
TABLE

EXAMPLES2
TABLE

SYS_C005728
INDEX


OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
SYS_C005781
INDEX

TABLE の 行数も確認します。両方とも50万行があります。

SELECT COUNT(*) FROM EXAMPLES;
SELECT COUNT(*) FROM EXAMPLES2;

SQL* Plus を exit

exit

Data Pump で Export(Full)

Data Pump を使用した Export には、基本的には4つのモードがあります。

  • フル : FULL
  • スキーマ : SCHEMAS
  • テーブル : TABLES
  • テーブルスペース : TABLESPACES

少々古いですが、こちらの資料に説明が載っています。Document と合わせて参照すると良いです。
https://www.oracle.com/technetwork/jp/ondemand/db-basic/20100908-expimp-beginner-244718-ja.pdf

実際に Export を行う前に、どれくらいの ファイルサイズになるかを確認することが可能です
estimate_only=y を指定すると良いです

blocks ベースの確認
estimate=blocks

expdp \'sys/mIfoO8_fai12#-gai897fao@sourcedb AS SYSDBA\' version=11.2 FULL=Y estimate=blocks estimate_only=y

163.7 MB と表示されています

[oracle@client ~]$ expdp \'sys/mIfoO8_fai12#-gai897fao@sourcedb AS SYSDBA\' version=11.2 FULL=Y estimate=blocks estimate_only=y 

Export: Release 11.2.0.4.0 - Production on Sat Nov 23 15:03:45 2019

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

Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
Starting "SYS"."SYS_EXPORT_FULL_01":  "sys/********@sourcedb AS SYSDBA" version=11.2 FULL=Y estimate=blocks estimate_only=y  
Estimate in progress using BLOCKS method... 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA 
.  estimated "SUGI"."EXAMPLES"                              80 MB 
.  estimated "SUGI"."EXAMPLES2"                             80 MB
.  estimated "ORDDATA"."ORDDCM_DOCS"                      1.25 MB
.  estimated "ORDDATA"."ORDDCM_STD_ATTRS"                  256 KB
.  estimated "ORDDATA"."ORDDCM_CT_PRED_OPRD"               192 KB
.  estimated "ORDDATA"."ORDDCM_MAPPING_DOCS"               192 KB
.  estimated "ORDDATA"."ORDDCM_ANON_ACTION_TYPES"           64 KB
.  estimated "ORDDATA"."ORDDCM_ANON_ATTRS"                  64 KB
.  estimated "ORDDATA"."ORDDCM_ANON_RULES"                  64 KB
.  estimated "ORDDATA"."ORDDCM_ANON_RULE_TYPES"             64 KB
.  estimated "ORDDATA"."ORDDCM_CT_ACTION"                   64 KB
.  estimated "ORDDATA"."ORDDCM_CT_DAREFS"                   64 KB
.  estimated "ORDDATA"."ORDDCM_CT_LOCATORPATHS"             64 KB
.  estimated "ORDDATA"."ORDDCM_CT_MACRO_DEP"                64 KB
.  estimated "ORDDATA"."ORDDCM_CT_MACRO_PAR"                64 KB
.  estimated "ORDDATA"."ORDDCM_CT_PRED"                     64 KB
.  estimated "ORDDATA"."ORDDCM_CT_PRED_PAR"                 64 KB
.  estimated "ORDDATA"."ORDDCM_CT_PRED_SET"                 64 KB
.  estimated "ORDDATA"."ORDDCM_DATA_MODEL"                  64 KB
.  estimated "ORDDATA"."ORDDCM_DICT_ATTRS"                  64 KB
.  estimated "ORDDATA"."ORDDCM_DOC_REFS"                    64 KB
.  estimated "ORDDATA"."ORDDCM_DOC_TYPES"                   64 KB
.  estimated "ORDDATA"."ORDDCM_INSTALL_DOCS"                64 KB
.  estimated "ORDDATA"."ORDDCM_INTERNAL_TAGS"               64 KB
.  estimated "ORDDATA"."ORDDCM_PREFS_DEF_VALUES_TAB"        64 KB
.  estimated "ORDDATA"."ORDDCM_PREFS_VALID_VALUES_TAB"      64 KB
.  estimated "ORDDATA"."ORDDCM_PREFS_LOOKUP"                64 KB
.  estimated "ORDDATA"."ORDDCM_PRV_ATTRS"                   64 KB
.  estimated "ORDDATA"."ORDDCM_RT_PREF_PARAMS"              64 KB
.  estimated "ORDDATA"."ORDDCM_UID_DEFS"                    64 KB
.  estimated "ORDDATA"."ORDDCM_VR_DT_MAP"                   64 KB
.  estimated "SYSTEM"."REPCAT$_AUDIT_ATTRIBUTE"             64 KB
.  estimated "SYSTEM"."REPCAT$_OBJECT_TYPES"                64 KB
.  estimated "SYSTEM"."REPCAT$_RESOLUTION_METHOD"           64 KB
.  estimated "SYSTEM"."REPCAT$_TEMPLATE_STATUS"             64 KB
.  estimated "SYSTEM"."REPCAT$_TEMPLATE_TYPES"              64 KB
.  estimated "ORDDATA"."ORDDCM_ANON_ATTRS_WRK"               0 KB
.  estimated "ORDDATA"."ORDDCM_ANON_RULES_WRK"               0 KB
.  estimated "ORDDATA"."ORDDCM_CT_ACTION_WRK"                0 KB
.  estimated "ORDDATA"."ORDDCM_CT_DAREFS_WRK"                0 KB
.  estimated "ORDDATA"."ORDDCM_CT_LOCATORPATHS_WRK"          0 KB
.  estimated "ORDDATA"."ORDDCM_CT_MACRO_DEP_WRK"             0 KB
.  estimated "ORDDATA"."ORDDCM_CT_MACRO_PAR_WRK"             0 KB
.  estimated "ORDDATA"."ORDDCM_CT_PRED_OPRD_WRK"             0 KB
.  estimated "ORDDATA"."ORDDCM_CT_PRED_PAR_WRK"              0 KB
.  estimated "ORDDATA"."ORDDCM_CT_PRED_SET_WRK"              0 KB
.  estimated "ORDDATA"."ORDDCM_CT_PRED_WRK"                  0 KB
.  estimated "ORDDATA"."ORDDCM_CT_VLD_MSG"                   0 KB
.  estimated "ORDDATA"."ORDDCM_DATA_MODEL_WRK"               0 KB
.  estimated "ORDDATA"."ORDDCM_DICT_ATTRS_WRK"               0 KB
.  estimated "ORDDATA"."ORDDCM_DOCS_WRK"                     0 KB
.  estimated "ORDDATA"."ORDDCM_DOC_REFS_WRK"                 0 KB
.  estimated "ORDDATA"."ORDDCM_MAPPED_PATHS"                 0 KB
.  estimated "ORDDATA"."ORDDCM_MAPPED_PATHS_WRK"             0 KB
.  estimated "ORDDATA"."ORDDCM_MAPPING_DOCS_WRK"             0 KB
.  estimated "ORDDATA"."ORDDCM_PRV_ATTRS_WRK"                0 KB
.  estimated "ORDDATA"."ORDDCM_RT_PREF_PARAMS_WRK"           0 KB
.  estimated "ORDDATA"."ORDDCM_STD_ATTRS_WRK"                0 KB
.  estimated "ORDDATA"."ORDDCM_STORED_TAGS"                  0 KB
.  estimated "ORDDATA"."ORDDCM_STORED_TAGS_WRK"              0 KB
.  estimated "ORDDATA"."ORDDCM_UID_DEFS_WRK"                 0 KB
.  estimated "OUTLN"."OL$"                                   0 KB
.  estimated "OUTLN"."OL$HINTS"                              0 KB
.  estimated "OUTLN"."OL$NODES"                              0 KB
.  estimated "OWBSYS"."OWBRTPS"                              0 KB
.  estimated "SYSTEM"."DEF$_AQCALL"                          0 KB
.  estimated "SYSTEM"."DEF$_AQERROR"                         0 KB
.  estimated "SYSTEM"."DEF$_CALLDEST"                        0 KB
.  estimated "SYSTEM"."DEF$_DEFAULTDEST"                     0 KB
.  estimated "SYSTEM"."DEF$_DESTINATION"                     0 KB
.  estimated "SYSTEM"."DEF$_ERROR"                           0 KB
.  estimated "SYSTEM"."DEF$_LOB"                             0 KB
.  estimated "SYSTEM"."DEF$_ORIGIN"                          0 KB
.  estimated "SYSTEM"."DEF$_PROPAGATOR"                      0 KB
.  estimated "SYSTEM"."DEF$_PUSHED_TRANSACTIONS"             0 KB
.  estimated "SYSTEM"."MVIEW$_ADV_INDEX"                     0 KB
.  estimated "SYSTEM"."MVIEW$_ADV_PARTITION"                 0 KB
.  estimated "SYSTEM"."REPCAT$_AUDIT_COLUMN"                 0 KB
.  estimated "SYSTEM"."REPCAT$_COLUMN_GROUP"                 0 KB
.  estimated "SYSTEM"."REPCAT$_CONFLICT"                     0 KB
.  estimated "SYSTEM"."REPCAT$_DDL"                          0 KB
.  estimated "SYSTEM"."REPCAT$_EXCEPTIONS"                   0 KB
.  estimated "SYSTEM"."REPCAT$_EXTENSION"                    0 KB
.  estimated "SYSTEM"."REPCAT$_FLAVORS"                      0 KB
.  estimated "SYSTEM"."REPCAT$_FLAVOR_OBJECTS"               0 KB
.  estimated "SYSTEM"."REPCAT$_GENERATED"                    0 KB
.  estimated "SYSTEM"."REPCAT$_GROUPED_COLUMN"               0 KB
.  estimated "SYSTEM"."REPCAT$_INSTANTIATION_DDL"            0 KB
.  estimated "SYSTEM"."REPCAT$_KEY_COLUMNS"                  0 KB
.  estimated "SYSTEM"."REPCAT$_OBJECT_PARMS"                 0 KB
.  estimated "SYSTEM"."REPCAT$_PARAMETER_COLUMN"             0 KB
.  estimated "SYSTEM"."REPCAT$_PRIORITY"                     0 KB
.  estimated "SYSTEM"."REPCAT$_PRIORITY_GROUP"               0 KB
.  estimated "SYSTEM"."REPCAT$_REFRESH_TEMPLATES"            0 KB
.  estimated "SYSTEM"."REPCAT$_REPCAT"                       0 KB
.  estimated "SYSTEM"."REPCAT$_REPCATLOG"                    0 KB
.  estimated "SYSTEM"."REPCAT$_REPCOLUMN"                    0 KB
.  estimated "SYSTEM"."REPCAT$_REPGROUP_PRIVS"               0 KB
.  estimated "SYSTEM"."REPCAT$_REPOBJECT"                    0 KB
.  estimated "SYSTEM"."REPCAT$_REPPROP"                      0 KB
.  estimated "SYSTEM"."REPCAT$_REPSCHEMA"                    0 KB
.  estimated "SYSTEM"."REPCAT$_RESOLUTION"                   0 KB 
.  estimated "SYSTEM"."REPCAT$_RESOLUTION_STATISTICS"        0 KB
.  estimated "SYSTEM"."REPCAT$_RESOL_STATS_CONTROL"          0 KB
.  estimated "SYSTEM"."REPCAT$_RUNTIME_PARMS"                0 KB
.  estimated "SYSTEM"."REPCAT$_SITES_NEW"                    0 KB
.  estimated "SYSTEM"."REPCAT$_SITE_OBJECTS"                 0 KB
.  estimated "SYSTEM"."REPCAT$_SNAPGROUP"                    0 KB
.  estimated "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS"             0 KB
.  estimated "SYSTEM"."REPCAT$_TEMPLATE_PARMS"               0 KB
.  estimated "SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS"           0 KB
.  estimated "SYSTEM"."REPCAT$_TEMPLATE_SITES"               0 KB
.  estimated "SYSTEM"."REPCAT$_TEMPLATE_TARGETS"             0 KB
.  estimated "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS"          0 KB
.  estimated "SYSTEM"."REPCAT$_USER_PARM_VALUES"             0 KB
.  estimated "SYSTEM"."SQLPLUS_PRODUCT_PROFILE"              0 KB
Total estimation using BLOCKS method: 163.7 MB
Job "SYS"."SYS_EXPORT_FULL_01" successfully completed at Sat Nov 23 15:03:55 2019 elapsed 0 00:00:09 

[oracle@client ~]$  

統計情報ベースの確認

estimate=statistics

expdp \'sys/mIfoO8_fai12#-gai897fao@sourcedb AS SYSDBA\' version=11.2 FULL=Y estimate=statistics estimate_only=y

実行例
66.76 MB と表示されています。
EXAMPLES2 が統計情報として収集されていなく、少々甘い見積となっています。
ただ、統計情報が最新の情報であれば、精密な見積となるため、使い分けることが可能です。

[oracle@client ~]$ expdp \'sys/mIfoO8_fai12#-gai897fao@sourcedb AS SYSDBA\' version=11.2 FULL=Y estimate=statistics estimate_only=y 

Export: Release 11.2.0.4.0 - Production on Sat Nov 23 15:04:33 2019

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

Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
Starting "SYS"."SYS_EXPORT_FULL_01":  "sys/********@sourcedb AS SYSDBA" version=11.2 FULL=Y estimate=statistics estimate_only=y  
Estimate in progress using STATISTICS method... 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA 
.  estimated "SUGI"."EXAMPLES"                           66.76 MB 
.  estimated "ORDDATA"."ORDDCM_STD_ATTRS"                178.2 KB
.  estimated "ORDDATA"."ORDDCM_UID_DEFS"                 32.25 KB
.  estimated "ORDDATA"."ORDDCM_DICT_ATTRS"               27.06 KB
.  estimated "ORDDATA"."ORDDCM_DOCS"                     20.90 KB
.  estimated "ORDDATA"."ORDDCM_CT_PRED_OPRD"             11.29 KB
.  estimated "ORDDATA"."ORDDCM_CT_LOCATORPATHS"          9.527 KB
.  estimated "ORDDATA"."ORDDCM_PRV_ATTRS"                9.409 KB
.  estimated "ORDDATA"."ORDDCM_PREFS_LOOKUP"             8.629 KB
.  estimated "ORDDATA"."ORDDCM_CT_PRED_SET"              8.588 KB
.  estimated "ORDDATA"."ORDDCM_ANON_ATTRS"               8.415 KB
.  estimated "ORDDATA"."ORDDCM_RT_PREF_PARAMS"           8.221 KB
.  estimated "ORDDATA"."ORDDCM_CT_PRED"                  7.946 KB
.  estimated "ORDDATA"."ORDDCM_MAPPING_DOCS"             7.373 KB
.  estimated "ORDDATA"."ORDDCM_DOC_TYPES"                6.894 KB
.  estimated "SYSTEM"."REPCAT$_OBJECT_TYPES"             6.730 KB
.  estimated "ORDDATA"."ORDDCM_CT_ACTION"                6.559 KB
.  estimated "ORDDATA"."ORDDCM_INSTALL_DOCS"             6.456 KB
.  estimated "ORDDATA"."ORDDCM_DOC_REFS"                 6.395 KB
.  estimated "ORDDATA"."ORDDCM_VR_DT_MAP"                6.371 KB
.  estimated "SYSTEM"."REPCAT$_AUDIT_ATTRIBUTE"           6.25 KB
.  estimated "SYSTEM"."REPCAT$_TEMPLATE_TYPES"           6.226 KB
.  estimated "ORDDATA"."ORDDCM_ANON_RULES"               6.209 KB
.  estimated "ORDDATA"."ORDDCM_INTERNAL_TAGS"            6.048 KB
.  estimated "ORDDATA"."ORDDCM_PREFS_VALID_VALUES_TAB"   5.960 KB
.  estimated "ORDDATA"."ORDDCM_CT_DAREFS"                5.925 KB
.  estimated "ORDDATA"."ORDDCM_CT_PRED_PAR"              5.887 KB
.  estimated "ORDDATA"."ORDDCM_DATA_MODEL"               5.821 KB
.  estimated "SYSTEM"."REPCAT$_RESOLUTION_METHOD"        5.749 KB
.  estimated "ORDDATA"."ORDDCM_ANON_RULE_TYPES"          5.518 KB
.  estimated "ORDDATA"."ORDDCM_ANON_ACTION_TYPES"        5.472 KB
.  estimated "SYSTEM"."REPCAT$_TEMPLATE_STATUS"          5.468 KB
.  estimated "ORDDATA"."ORDDCM_CT_MACRO_PAR"             5.460 KB
.  estimated "ORDDATA"."ORDDCM_CT_MACRO_DEP"             5.439 KB
.  estimated "ORDDATA"."ORDDCM_PREFS_DEF_VALUES_TAB"     5.263 KB
.  estimated "SUGI"."EXAMPLES2"                          4.683 KB
.  estimated "ORDDATA"."ORDDCM_ANON_ATTRS_WRK"               0 KB
.  estimated "ORDDATA"."ORDDCM_ANON_RULES_WRK"               0 KB
.  estimated "ORDDATA"."ORDDCM_CT_ACTION_WRK"                0 KB
.  estimated "ORDDATA"."ORDDCM_CT_DAREFS_WRK"                0 KB
.  estimated "ORDDATA"."ORDDCM_CT_LOCATORPATHS_WRK"          0 KB
.  estimated "ORDDATA"."ORDDCM_CT_MACRO_DEP_WRK"             0 KB
.  estimated "ORDDATA"."ORDDCM_CT_MACRO_PAR_WRK"             0 KB
.  estimated "ORDDATA"."ORDDCM_CT_PRED_OPRD_WRK"             0 KB
.  estimated "ORDDATA"."ORDDCM_CT_PRED_PAR_WRK"              0 KB
.  estimated "ORDDATA"."ORDDCM_CT_PRED_SET_WRK"              0 KB
.  estimated "ORDDATA"."ORDDCM_CT_PRED_WRK"                  0 KB
.  estimated "ORDDATA"."ORDDCM_CT_VLD_MSG"                   0 KB
.  estimated "ORDDATA"."ORDDCM_DATA_MODEL_WRK"               0 KB
.  estimated "ORDDATA"."ORDDCM_DICT_ATTRS_WRK"               0 KB
.  estimated "ORDDATA"."ORDDCM_DOCS_WRK"                     0 KB
.  estimated "ORDDATA"."ORDDCM_DOC_REFS_WRK"                 0 KB
.  estimated "ORDDATA"."ORDDCM_MAPPED_PATHS"                 0 KB
.  estimated "ORDDATA"."ORDDCM_MAPPED_PATHS_WRK"             0 KB
.  estimated "ORDDATA"."ORDDCM_MAPPING_DOCS_WRK"             0 KB
.  estimated "ORDDATA"."ORDDCM_PRV_ATTRS_WRK"                0 KB
.  estimated "ORDDATA"."ORDDCM_RT_PREF_PARAMS_WRK"           0 KB
.  estimated "ORDDATA"."ORDDCM_STD_ATTRS_WRK"                0 KB
.  estimated "ORDDATA"."ORDDCM_STORED_TAGS"                  0 KB
.  estimated "ORDDATA"."ORDDCM_STORED_TAGS_WRK"              0 KB
.  estimated "ORDDATA"."ORDDCM_UID_DEFS_WRK"                 0 KB
.  estimated "OUTLN"."OL$"                                   0 KB
.  estimated "OUTLN"."OL$HINTS"                              0 KB
.  estimated "OUTLN"."OL$NODES"                              0 KB
.  estimated "OWBSYS"."OWBRTPS"                              0 KB
.  estimated "SYSTEM"."DEF$_AQCALL"                          0 KB
.  estimated "SYSTEM"."DEF$_AQERROR"                         0 KB
.  estimated "SYSTEM"."DEF$_CALLDEST"                        0 KB
.  estimated "SYSTEM"."DEF$_DEFAULTDEST"                     0 KB
.  estimated "SYSTEM"."DEF$_DESTINATION"                     0 KB
.  estimated "SYSTEM"."DEF$_ERROR"                           0 KB
.  estimated "SYSTEM"."DEF$_LOB"                             0 KB
.  estimated "SYSTEM"."DEF$_ORIGIN"                          0 KB
.  estimated "SYSTEM"."DEF$_PROPAGATOR"                      0 KB
.  estimated "SYSTEM"."DEF$_PUSHED_TRANSACTIONS"             0 KB
.  estimated "SYSTEM"."MVIEW$_ADV_INDEX"                     0 KB
.  estimated "SYSTEM"."MVIEW$_ADV_PARTITION"                 0 KB
.  estimated "SYSTEM"."REPCAT$_AUDIT_COLUMN"                 0 KB
.  estimated "SYSTEM"."REPCAT$_COLUMN_GROUP"                 0 KB
.  estimated "SYSTEM"."REPCAT$_CONFLICT"                     0 KB
.  estimated "SYSTEM"."REPCAT$_DDL"                          0 KB
.  estimated "SYSTEM"."REPCAT$_EXCEPTIONS"                   0 KB
.  estimated "SYSTEM"."REPCAT$_EXTENSION"                    0 KB
.  estimated "SYSTEM"."REPCAT$_FLAVORS"                      0 KB
.  estimated "SYSTEM"."REPCAT$_FLAVOR_OBJECTS"               0 KB
.  estimated "SYSTEM"."REPCAT$_GENERATED"                    0 KB
.  estimated "SYSTEM"."REPCAT$_GROUPED_COLUMN"               0 KB
.  estimated "SYSTEM"."REPCAT$_INSTANTIATION_DDL"            0 KB
.  estimated "SYSTEM"."REPCAT$_KEY_COLUMNS"                  0 KB
.  estimated "SYSTEM"."REPCAT$_OBJECT_PARMS"                 0 KB
.  estimated "SYSTEM"."REPCAT$_PARAMETER_COLUMN"             0 KB
.  estimated "SYSTEM"."REPCAT$_PRIORITY"                     0 KB
.  estimated "SYSTEM"."REPCAT$_PRIORITY_GROUP"               0 KB
.  estimated "SYSTEM"."REPCAT$_REFRESH_TEMPLATES"            0 KB
.  estimated "SYSTEM"."REPCAT$_REPCAT"                       0 KB
.  estimated "SYSTEM"."REPCAT$_REPCATLOG"                    0 KB
.  estimated "SYSTEM"."REPCAT$_REPCOLUMN"                    0 KB
.  estimated "SYSTEM"."REPCAT$_REPGROUP_PRIVS"               0 KB
.  estimated "SYSTEM"."REPCAT$_REPOBJECT"                    0 KB
.  estimated "SYSTEM"."REPCAT$_REPPROP"                      0 KB
.  estimated "SYSTEM"."REPCAT$_REPSCHEMA"                    0 KB
.  estimated "SYSTEM"."REPCAT$_RESOLUTION"                   0 KB 
.  estimated "SYSTEM"."REPCAT$_RESOLUTION_STATISTICS"        0 KB
.  estimated "SYSTEM"."REPCAT$_RESOL_STATS_CONTROL"          0 KB
.  estimated "SYSTEM"."REPCAT$_RUNTIME_PARMS"                0 KB
.  estimated "SYSTEM"."REPCAT$_SITES_NEW"                    0 KB
.  estimated "SYSTEM"."REPCAT$_SITE_OBJECTS"                 0 KB
.  estimated "SYSTEM"."REPCAT$_SNAPGROUP"                    0 KB
.  estimated "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS"             0 KB
.  estimated "SYSTEM"."REPCAT$_TEMPLATE_PARMS"               0 KB
.  estimated "SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS"           0 KB
.  estimated "SYSTEM"."REPCAT$_TEMPLATE_SITES"               0 KB
.  estimated "SYSTEM"."REPCAT$_TEMPLATE_TARGETS"             0 KB
.  estimated "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS"          0 KB
.  estimated "SYSTEM"."REPCAT$_USER_PARM_VALUES"             0 KB
.  estimated "SYSTEM"."SQLPLUS_PRODUCT_PROFILE"              0 KB
Total estimation using STATISTICS method: 67.22 MB
Job "SYS"."SYS_EXPORT_FULL_01" successfully completed at Sat Nov 23 15:04:38 2019 elapsed 0 00:00:05 

[oracle@client ~]$  

それでは、これから実際のデータのエクスポートを行っていきます。
expdp の引数で様々なパラメータを指定することが出来ますが、文字のエスケープ処理などかなり面倒なので、パラメータファイルを使用するのがお勧めです。

作業用ディレクトリを作成します

mkdir ~/datapump
cd ~/datapump

ヒアドキュメントで、以下の Import 用のパラメータファイルを作成します

cat <<'EOF' > ~/datapump/full_paramfile.par
VERSION=11.2
DIRECTORY=dpump_dir
DUMPFILE=full.dmp
LOGFILE=full.log
FULL=Y
FLASHBACK_TIME="TO_TIMESTAMP('2019/11/23 15:55:00', 'YYYY/MM/DD HH24:MI:SS')"
EOF

オプションの説明

  • VERSION : エクスポートするデータベース・オブジェクトのバージョンを指定。例えば、12と指定することで、Oracle DB 12c に Import することの出来るダンプファイルが生成される
  • DIRECTORY : DIRECTORY オブジェクトの指定
  • DUMPFILE : 出力されるダンプファイルの名前。移行元の Oracle DB 側のディレクトリに出力される
  • LOGFILE : エクスポートを実行したときに出力される実行ログファイルの名前。移行元の Oracle DB 側のディレクトリに出力される
  • FULL : Export のモードを指定
  • FLASHBACK_TIME : データの整合性を維持した一貫性データ取得を行うことが可能。これを指定しないと、複数のTable間でデータの取得時刻がずれることにより、正しいデータ取得を行うことが出来ない。Oracle DB の OS が UTC で動作している場合は、UTC 前提の時刻指定が必要

作成したパラメータファイルを指定して、Data Pump を使用したエクスポートを行います。

expdp \'sys/mIfoO8_fai12#-gai897fao@sourcedb AS SYSDBA\' PARFILE=~/datapump/full_paramfile.par

実行例
今回のテストデータの量だと、3分ほどで完了します

[oracle@client datapump]$ expdp \'sys/mIfoO8_fai12#-gai897fao@sourcedb AS SYSDBA\' PARFILE=~/datapump/full_paramfile.par 

Export: Release 11.2.0.4.0 - Production on Sat Nov 23 15:55:50 2019

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

Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production     
With the Real Application Clusters and Automatic Storage Management options 
Starting "SYS"."SYS_EXPORT_FULL_01":  "sys/********@sourcedb AS SYSDBA" PARFILE=/home/oracle/datapump/full_paramfile.par  
Estimate in progress using BLOCKS method... 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA 
Total estimation using BLOCKS method: 170.9 MB 
Processing object type DATABASE_EXPORT/TABLESPACE 
Processing object type DATABASE_EXPORT/PASSWORD_VERIFY_FUNCTION 
Processing object type DATABASE_EXPORT/PROFILE 
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER 
Processing object type DATABASE_EXPORT/ROLE 
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT 
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT 
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT 
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE 
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA 
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK 
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE 
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT 
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY 
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT 
Processing object type DATABASE_EXPORT/CONTEXT 
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM 
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM 
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC 
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM 
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ 
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM 
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA 
>>> DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled 
>>> DBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabled 
>>> DBMS_AW_EXP: SYS.AW$AWCREATE: OLAP not enabled 
>>> DBMS_AW_EXP: SYS.AW$AWCREATE10G: OLAP not enabled
>>> DBMS_AW_EXP: SYS.AW$AWXML: OLAP not enabled 
>>> DBMS_AW_EXP: SYS.AW$AWREPORT: OLAP not enabled
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT 
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC 
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION 
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE 
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION 
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS 
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW 
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT 
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT 
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_TABLE_ACTION 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER 
>>> DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled 
>>> DBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabled 
>>> DBMS_AW_EXP: SYS.AW$AWCREATE: OLAP not enabled 
>>> DBMS_AW_EXP: SYS.AW$AWCREATE10G: OLAP not enabled
>>> DBMS_AW_EXP: SYS.AW$AWXML: OLAP not enabled 
>>> DBMS_AW_EXP: SYS.AW$AWREPORT: OLAP not enabled 
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA 
Processing object type DATABASE_EXPORT/SCHEMA/PASSWORD_HISTORY 
Processing object type DATABASE_EXPORT/AUDIT 
. . exported "SUGI"."EXAMPLES"                           68.59 MB  500000 rows 
. . exported "SUGI"."EXAMPLES2"                          68.59 MB  500000 rows 
. . exported "ORDDATA"."ORDDCM_DOCS"                     177.5 KB       9 rows 
. . exported "ORDDATA"."ORDDCM_DOCS_WRK"                 7.390 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_STD_ATTRS"                188.8 KB    2415 rows 
. . exported "ORDDATA"."ORDDCM_STD_ATTRS_WRK"            8.726 KB       0 rows 
. . exported "SYSTEM"."DEF$_LOB"                         6.664 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_CT_PRED_OPRD"             13.84 KB      53 rows 
. . exported "ORDDATA"."ORDDCM_CT_PRED_OPRD_WRK"         6.171 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_MAPPING_DOCS"             7.890 KB       1 rows 
. . exported "ORDDATA"."ORDDCM_MAPPING_DOCS_WRK"         7.820 KB       0 rows 
. . exported "OUTLN"."OL$HINTS"                          13.12 KB       0 rows 
. . exported "SYSTEM"."DEF$_AQCALL"                      14.73 KB       0 rows 
. . exported "SYSTEM"."DEF$_AQERROR"                     14.73 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_EXCEPTIONS"               7.843 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_INSTANTIATION_DDL"         6.25 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_RUNTIME_PARMS"            5.859 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS"         10.72 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_TEMPLATE_PARMS"           7.085 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_USER_PARM_VALUES"         6.257 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_ANON_ACTION_TYPES"        5.484 KB       4 rows 
. . exported "ORDDATA"."ORDDCM_ANON_ATTRS"               8.703 KB      37 rows 
. . exported "ORDDATA"."ORDDCM_ANON_ATTRS_WRK"           7.062 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_ANON_RULES"               6.289 KB       3 rows 
. . exported "ORDDATA"."ORDDCM_ANON_RULES_WRK"           6.242 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_ANON_RULE_TYPES"          5.546 KB       3 rows 
. . exported "ORDDATA"."ORDDCM_CT_ACTION"                6.664 KB       7 rows 
. . exported "ORDDATA"."ORDDCM_CT_ACTION_WRK"            6.242 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_CT_DAREFS"                6.187 KB      72 rows 
. . exported "ORDDATA"."ORDDCM_CT_DAREFS_WRK"            5.437 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_CT_LOCATORPATHS"          10.07 KB      95 rows 
. . exported "ORDDATA"."ORDDCM_CT_LOCATORPATHS_WRK"       6.75 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_CT_MACRO_DEP"             5.460 KB       1 rows 
. . exported "ORDDATA"."ORDDCM_CT_MACRO_DEP_WRK"         5.437 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_CT_MACRO_PAR"             5.476 KB       2 rows 
. . exported "ORDDATA"."ORDDCM_CT_MACRO_PAR_WRK"         5.429 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_CT_PRED"                  8.320 KB      61 rows 
. . exported "ORDDATA"."ORDDCM_CT_PRED_PAR"              5.937 KB       3 rows 
. . exported "ORDDATA"."ORDDCM_CT_PRED_PAR_WRK"          5.835 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_CT_PRED_SET"              8.906 KB       9 rows 
. . exported "ORDDATA"."ORDDCM_CT_PRED_SET_WRK"          7.953 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_CT_PRED_WRK"              7.132 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_DATA_MODEL"               5.859 KB       1 rows 
. . exported "ORDDATA"."ORDDCM_DATA_MODEL_WRK"           5.828 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_DICT_ATTRS"               33.95 KB    2418 rows 
. . exported "ORDDATA"."ORDDCM_DICT_ATTRS_WRK"           5.843 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_DOC_REFS"                   6.5 KB       7 rows 
. . exported "ORDDATA"."ORDDCM_DOC_REFS_WRK"              6.25 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_DOC_TYPES"                6.976 KB       8 rows 
. . exported "ORDDATA"."ORDDCM_INSTALL_DOCS"             6.539 KB       9 rows 
. . exported "ORDDATA"."ORDDCM_INTERNAL_TAGS"            6.210 KB      42 rows 
. . exported "ORDDATA"."ORDDCM_MAPPED_PATHS"             8.929 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_MAPPED_PATHS_WRK"         8.937 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_PREFS_DEF_VALUES_TAB"     5.679 KB       7 rows 
. . exported "ORDDATA"."ORDDCM_PREFS_LOOKUP"             9.789 KB      13 rows 
. . exported "ORDDATA"."ORDDCM_PREFS_VALID_VALUES_TAB"   6.492 KB      33 rows 
. . exported "ORDDATA"."ORDDCM_PRV_ATTRS"                9.804 KB       3 rows 
. . exported "ORDDATA"."ORDDCM_PRV_ATTRS_WRK"            9.554 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_RT_PREF_PARAMS"           8.375 KB      13 rows 
. . exported "ORDDATA"."ORDDCM_RT_PREF_PARAMS_WRK"       6.656 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_STORED_TAGS"              5.835 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_STORED_TAGS_WRK"          5.843 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_UID_DEFS"                 33.49 KB     245 rows 
. . exported "ORDDATA"."ORDDCM_UID_DEFS_WRK"             9.242 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_VR_DT_MAP"                6.507 KB      32 rows 
. . exported "OUTLN"."OL$"                               10.17 KB       0 rows 
. . exported "OUTLN"."OL$NODES"                          7.781 KB       0 rows 
. . exported "SYSTEM"."DEF$_CALLDEST"                        7 KB       0 rows 
. . exported "SYSTEM"."DEF$_DEFAULTDEST"                 5.007 KB       0 rows 
. . exported "SYSTEM"."DEF$_DESTINATION"                 13.50 KB       0 rows 
. . exported "SYSTEM"."DEF$_ERROR"                       8.210 KB       0 rows 
. . exported "SYSTEM"."DEF$_ORIGIN"                      7.390 KB       0 rows 
. . exported "SYSTEM"."DEF$_PROPAGATOR"                  5.796 KB       0 rows 
. . exported "SYSTEM"."DEF$_PUSHED_TRANSACTIONS"         6.218 KB       0 rows 
. . exported "SYSTEM"."MVIEW$_ADV_INDEX"                 7.812 KB       0 rows 
. . exported "SYSTEM"."MVIEW$_ADV_PARTITION"             6.210 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_AUDIT_ATTRIBUTE"          6.328 KB       2 rows 
. . exported "SYSTEM"."REPCAT$_AUDIT_COLUMN"             7.843 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_COLUMN_GROUP"             6.210 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_CONFLICT"                 6.226 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_DDL"                      7.406 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_EXTENSION"                9.890 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_FLAVORS"                  7.390 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_FLAVOR_OBJECTS"           8.187 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_GENERATED"                8.640 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_GROUPED_COLUMN"           6.601 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_KEY_COLUMNS"              6.203 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_OBJECT_PARMS"             5.429 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_OBJECT_TYPES"             6.882 KB      28 rows 
. . exported "SYSTEM"."REPCAT$_PARAMETER_COLUMN"         8.679 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_PRIORITY"                 9.070 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_PRIORITY_GROUP"           6.656 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_REFRESH_TEMPLATES"        10.69 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_REPCAT"                   7.398 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_REPCATLOG"                13.09 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_REPCOLUMN"                13.79 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_REPGROUP_PRIVS"           7.390 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_REPOBJECT"                10.67 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_REPPROP"                  8.226 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_REPSCHEMA"                8.609 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_RESOLUTION"                8.25 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_RESOLUTION_METHOD"        5.835 KB      19 rows 
. . exported "SYSTEM"."REPCAT$_RESOLUTION_STATISTICS"    8.265 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_RESOL_STATS_CONTROL"      7.835 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_SITES_NEW"                7.015 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_SITE_OBJECTS"             6.210 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_SNAPGROUP"                    7 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS"       7.046 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_TEMPLATE_SITES"           9.062 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_TEMPLATE_STATUS"          5.484 KB       3 rows 
. . exported "SYSTEM"."REPCAT$_TEMPLATE_TARGETS"         6.648 KB       0 rows 
. . exported "SYSTEM"."REPCAT$_TEMPLATE_TYPES"           6.289 KB       2 rows 
. . exported "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS"      5.828 KB       0 rows 
. . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE"          7.867 KB       0 rows 
. . exported "ORDDATA"."ORDDCM_CT_VLD_MSG"                   0 KB       0 rows 
. . exported "OWBSYS"."OWBRTPS"                              0 KB       0 rows
Master table "SYS"."SYS_EXPORT_FULL_01" successfully loaded/unloaded 
****************************************************************************** 
Dump file set for SYS.SYS_EXPORT_FULL_01 is:
  /tmp/datapump/full.dmp
Job "SYS"."SYS_EXPORT_FULL_01" successfully completed at Sat Nov 23 15:57:01 2019 elapsed 0 00:01:11 

[oracle@client datapump]$  

移行元の Oracle DB サーバにSSHログインし、Data Pump の出力先 /tmp/datapump を確認します

[opc@sourcedb datapump]$ ls -lha /tmp/datapump 
total 144M 
drwxrwxrwx  2 opc    opc      4.0K Nov 23 15:55 .
drwxrwxrwt 13 root   root     4.0K Nov 23 15:59 ..
-rw-r-----  1 oracle asmadmin 144M Nov 23 15:57 full.dmp
-rw-r--r--  1 oracle asmadmin  14K Nov 23 15:57 full.log
[opc@sourcedb datapump]$ 

scp で データ移行先へコピー

root user で ファイルのパーミッションを変更

chmod 666 full.dmp

ocp user で scp

cd /tmp/datapump/
scp full.dmp opc@10.0.100.4:~

Data Pump で Import

データ移行先へ Data Pump を使用して Import を行います。

Dump File 格納先を指定

データ移行先の Oracle DB 上で、Dump File を格納するディレクトリを作成します。

mkdir /tmp/datapump
chmod 777 /tmp/datapump

scp でコピーしたダンプファイルを移動します

mv full.dmp /tmp/datapump/

Client から、データ移行先の Oracle DB へ SQL*Plus を使用して接続を行います

sqlplus sys/mIfoO8_fai12#-gai897fao@destidb AS SYSDBA

実行例

[oracle@client datapump]$ sqlplus sys/mIfoO8_fai12#-gai897fao@destidb AS SYSDBA 

SQL*Plus: Release 11.2.0.4.0 Production on Sat Nov 23 16:03:34 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL>

現時点では、Directory Object を作成していないため、何も存在しないことを確認します

select directory_name, directory_path from dba_directories where directory_name='DPUMP_DIR';

実行例
no rows selected と表示されればOKです

SQL> select directory_name, directory_path from dba_directories where directory_name='DPUMP_DIR'; 

no rows selected

SQL> 

Data Pump の出力先ディレクトリを Directory オブジェクトとして作成します

create directory dpump_dir as '/tmp/datapump';

実行例

SQL> create directory dpump_dir as '/tmp/datapump'; 

Directory created.

SQL> 

確認します

select directory_name, directory_path from dba_directories where directory_name='DPUMP_DIR';

実行例
先ほどは空白でしたが、定義した内容が取得できました

SQL> select directory_name, directory_path from dba_directories where directory_name='DPUMP_DIR'; 

DIRECTORY_NAME
------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
DPUMP_DIR
/tmp/datapump

Dump File 出力先の Directory へ権限の付与を行います

grant read, write on directory dpump_dir to system;

実行例

SQL> grant read, write on directory dpump_dir to system; 

Grant succeeded.

SQL> 

SQL*Plus を終了

exit

Data Pump で Import

Client に SSH ログインします。

ヒアドキュメントで、以下の Import 用のパラメータファイルを作成します

cat <<'EOF' > ~/datapump/full_paramfile_import.par
DIRECTORY=dpump_dir
DUMPFILE=full.dmp
FULL=Y
EOF

Import を行う

impdp \'sys/mIfoO8_fai12#-gai897fao@destidb AS SYSDBA\' PARFILE=~/datapump/full_paramfile_import.par

実行例
既に存在している Object は、Import エラーとなる

[oracle@client datapump]$ impdp \'sys/mIfoO8_fai12#-gai897fao@destidb AS SYSDBA\' PARFILE=~/datapump/full_paramfile_import.par 

Import: Release 11.2.0.4.0 - Production on Sat Nov 23 16:33:16 2019

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

Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded 
Starting "SYS"."SYS_IMPORT_FULL_01":  "sys/********@destidb AS SYSDBA" PARFILE=/home/oracle/datapump/full_paramfile_import.par  
Processing object type DATABASE_EXPORT/TABLESPACE 
ORA-31684: Object type TABLESPACE:"UNDOTBS1" already exists 
ORA-31684: Object type TABLESPACE:"TEMP" already exists
ORA-31684: Object type TABLESPACE:"USERS" already exists
Processing object type DATABASE_EXPORT/PASSWORD_VERIFY_FUNCTION 
ORA-31684: Object type PASSWORD_VERIFY_FUNCTION already exists 
Processing object type DATABASE_EXPORT/PROFILE 
Processing object type DATABASE_EXPORT/SYS_USER/USER 
Processing object type DATABASE_EXPORT/SCHEMA/USER 
ORA-31684: Object type USER:"OUTLN" already exists 
ORA-31684: Object type USER:"ORDDATA" already exists
ORA-31684: Object type USER:"OLAPSYS" already exists
ORA-31684: Object type USER:"MDDATA" already exists
ORA-31684: Object type USER:"SPATIAL_WFS_ADMIN_USR" already exists
ORA-31684: Object type USER:"SPATIAL_CSW_ADMIN_USR" already exists
ORA-31684: Object type USER:"OWBSYS" already exists
ORA-31684: Object type USER:"OWBSYS_AUDIT" already exists
Processing object type DATABASE_EXPORT/ROLE 
ORA-31684: Object type ROLE:"SELECT_CATALOG_ROLE" already exists 
ORA-31684: Object type ROLE:"EXECUTE_CATALOG_ROLE" already exists
ORA-31684: Object type ROLE:"DELETE_CATALOG_ROLE" already exists
ORA-31684: Object type ROLE:"DBFS_ROLE" already exists
ORA-31684: Object type ROLE:"AQ_ADMINISTRATOR_ROLE" already exists
ORA-31684: Object type ROLE:"AQ_USER_ROLE" already exists
ORA-31684: Object type ROLE:"ADM_PARALLEL_EXECUTE_TASK" already exists
ORA-31684: Object type ROLE:"GATHER_SYSTEM_STATISTICS" already exists
ORA-31684: Object type ROLE:"RECOVERY_CATALOG_OWNER" already exists
ORA-31684: Object type ROLE:"SCHEDULER_ADMIN" already exists
ORA-31684: Object type ROLE:"HS_ADMIN_SELECT_ROLE" already exists
ORA-31684: Object type ROLE:"HS_ADMIN_EXECUTE_ROLE" already exists
ORA-31684: Object type ROLE:"HS_ADMIN_ROLE" already exists
ORA-39083: Object type ROLE failed to create with error:
ORA-00439: feature not enabled: Enterprise User Security
Failing sql is:
 CREATE ROLE "GLOBAL_AQ_USER_ROLE" IDENTIFIED GLOBALLY
ORA-31684: Object type ROLE:"OEM_ADVISOR" already exists
ORA-31684: Object type ROLE:"OEM_MONITOR" already exists
ORA-31684: Object type ROLE:"WM_ADMIN_ROLE" already exists
ORA-31684: Object type ROLE:"JAVAUSERPRIV" already exists
ORA-31684: Object type ROLE:"JAVAIDPRIV" already exists
ORA-31684: Object type ROLE:"JAVASYSPRIV" already exists
ORA-31684: Object type ROLE:"JAVADEBUGPRIV" already exists
ORA-31684: Object type ROLE:"EJBCLIENT" already exists
ORA-31684: Object type ROLE:"JMXSERVER" already exists
ORA-31684: Object type ROLE:"JAVA_ADMIN" already exists
ORA-31684: Object type ROLE:"JAVA_DEPLOY" already exists
ORA-31684: Object type ROLE:"CTXAPP" already exists
ORA-31684: Object type ROLE:"XDBADMIN" already exists
ORA-31684: Object type ROLE:"XDB_SET_INVOKER" already exists
ORA-31684: Object type ROLE:"AUTHENTICATEDUSER" already exists
ORA-31684: Object type ROLE:"XDB_WEBSERVICES" already exists
ORA-31684: Object type ROLE:"XDB_WEBSERVICES_WITH_PUBLIC" already exists
ORA-31684: Object type ROLE:"XDB_WEBSERVICES_OVER_HTTP" already exists
ORA-31684: Object type ROLE:"ORDADMIN" already exists
ORA-31684: Object type ROLE:"CWM_USER" already exists
ORA-31684: Object type ROLE:"SPATIAL_WFS_ADMIN" already exists
ORA-31684: Object type ROLE:"WFS_USR_ROLE" already exists
ORA-31684: Object type ROLE:"SPATIAL_CSW_ADMIN" already exists
ORA-31684: Object type ROLE:"CSW_USR_ROLE" already exists
ORA-31684: Object type ROLE:"OWB$CLIENT" already exists
ORA-31684: Object type ROLE:"OWB_DESIGNCENTER_VIEW" already exists
ORA-31684: Object type ROLE:"OWB_USER" already exists
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT 
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT 
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT 
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE 
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA 
Processing object type DATABASE_EXPORT/RESOURCE_COST 
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK 
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE 
ORA-31684: Object type SEQUENCE:"SYSTEM"."MVIEW$_ADVSEQ_GENERIC" already exists 
ORA-31684: Object type SEQUENCE:"SYSTEM"."MVIEW$_ADVSEQ_ID" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_FLAVORS_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_FLAVOR_NAME_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_REPPROP_KEY" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT_LOG_SEQUENCE" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_REFRESH_TEMPLATES_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_USER_AUTHORIZATIONS_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_TEMPLATE_OBJECTS_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_TEMPLATE_PARMS_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_USER_PARM_VALUES_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_TEMPLATE_SITES_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_TEMP_OUTPUT_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_RUNTIME_PARMS_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."TEMPLATE$_TARGETS_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_EXCEPTIONS_S" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_DOCS_ID_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_STD_A_SA_ID_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_PRV_A_PA_ID_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_DICT_A_DA_ID_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_MPD_P_MPID_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_ANON_ATTRS_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_RT_PREF_P_PPID_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_UID_DEFS_UDID_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_STOREDTAGS_STID_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_DATA_MODEL_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_CT_PRED_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ORDDATA"."ORDDCM_CT_PRED_SET_SEQ" already exists
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT 
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_DOCS_ID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_DOCS_ID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_STD_A_SA_ID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_STD_A_SA_ID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_PRV_A_PA_ID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_PRV_A_PA_ID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_DICT_A_DA_ID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_DICT_A_DA_ID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_MPD_P_MPID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_MPD_P_MPID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_ANON_ATTRS_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_ANON_ATTRS_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_RT_PREF_P_PPID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_RT_PREF_P_PPID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_UID_DEFS_UDID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_UID_DEFS_UDID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_STOREDTAGS_STID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_STOREDTAGS_STID_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_DATA_MODEL_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_DATA_MODEL_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_CT_PRED_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_CT_PRED_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_CT_PRED_SET_SEQ" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type SEQUENCE:"ORDDATA"."ORDDCM_CT_PRED_SET_SEQ" already exists
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY 
ORA-31684: Object type DIRECTORY:"DATA_PUMP_DIR" already exists 
ORA-31684: Object type DIRECTORY:"XMLDIR" already exists
ORA-31684: Object type DIRECTORY:"DPUMP_DIR" already exists
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT 
Processing object type DATABASE_EXPORT/CONTEXT 
ORA-31684: Object type CONTEXT:"GLOBAL_AQCLNTDB_CTX" already exists 
ORA-31684: Object type CONTEXT:"DBFS_CONTEXT" already exists
ORA-31684: Object type CONTEXT:"REGISTRY$CTX" already exists
ORA-31684: Object type CONTEXT:"LT_CTX" already exists
ORA-31684: Object type CONTEXT:"DR$APPCTX" already exists
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM 
ORA-31684: Object type SYNONYM:"PUBLIC"."OL$" already exists 
ORA-31684: Object type SYNONYM:"PUBLIC"."OL$HINTS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."OL$NODES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."PRODUCT_PROFILE" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."PRODUCT_USER_PROFILE" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ORDDCM_DBRELEASE_DOCS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ORDDCM_DOCUMENTS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ORDDCM_DOCUMENT_TYPES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ORDDCM_CONSTRAINT_NAMES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ORDDCM_DOCUMENT_REFS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ORDDCM_CONFORMANCE_VLD_MSGS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM_CLASSIFY" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM_OLAP_CUBE" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM_OLAP_HIERARCHY" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM_OLAP_LEVEL" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM_OLAP_MEASURE" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM_OLAP_LEVEL_ATTRIBUTE" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM_OLAP_DIM_ATTRIBUTE" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM_OLAP_DIMENSION" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM_UTILITY" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM_EXCEPTIONS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_CATALOG_ENTITY_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_CATALOGS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_COLUMNS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_CUBE_DIM_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_CUBE_MEASURE_DIM_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_CUBE_MEASURE_MAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_CUBE_MEASURES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_CUBES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_DESCRIPTOR_TYPES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_DESCRIPTORS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_DIM_ATTR_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_DIM_ATTRIBUTES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_DIM_HIER_LEVEL_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_DIM_HIERARCHIES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_DIM_LEVEL_ATTR_MAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_DIM_LEVEL_ATTRIBUTES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_DIM_LEVELS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_DIMENSIONS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_ENTITY_DESC_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_FACT_LEVEL_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_FOREIGN_KEYS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_FUNCTION_ARGUMENTS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_FUNCTION_PARAMETERS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_FUNCTION_USAGES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_FUNCTIONS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_JOIN_KEY_COLUMN_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_KEY_COLUMN_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_KEYS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_LEVEL_KEY_COLUMN_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP_TABLES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_CATALOG_ENTITY_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_CATALOGS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_COLUMNS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_CUBE_DIM_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_CUBE_MEASURE_DIM_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_CUBE_MEASURE_MAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_CUBE_MEASURES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_CUBES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_DESCRIPTOR_TYPES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_DESCRIPTORS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_DIM_ATTR_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_DIM_ATTRIBUTES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_DIM_HIER_LEVEL_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_DIM_HIERARCHIES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_DIM_LEVEL_ATTR_MAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_DIM_LEVEL_ATTRIBUTES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_DIM_LEVELS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_DIMENSIONS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_ENTITY_DESC_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_FACT_LEVEL_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_FOREIGN_KEYS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_FUNCTION_ARGUMENTS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_FUNCTION_PARAMETERS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_FUNCTION_USAGES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_FUNCTIONS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_JOIN_KEY_COLUMN_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_KEY_COLUMN_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_KEYS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_LEVEL_KEY_COLUMN_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP_TABLES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAPMR_DIMENSIONS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAPMR_DIM_ATTRIBUTES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAPMR_ATTRIBUTES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAPMR_DIM_LEVELS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_EXCEPTIONS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_MANAGER" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_UTILITY" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_CATALOG" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_CUBE" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_DIMENSION" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_DIMENSION_ATTRIBUTE" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_HIERARCHY" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_LEVEL" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_LEVEL_ATTRIBUTE" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_MEASURE" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_VALIDATE" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_VERIFY_ACCESS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_EXPORT" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_DELETE" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_SECURITY" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_TABLE_MAP" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_PC_TRANSFORM" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_CLASSIFY" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_CUBES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_CUBE_MEASURES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_CUBE_DIM_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_CUBE_MEAS_DIM_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_DIMENSIONS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_DIM_HIERARCHIES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_DIM_LEVELS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_DIM_HIER_LEVEL_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_DIM_ATTRIBUTES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_DIM_ATTR_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_DIM_LEVEL_ATTRIBUTES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_CUBE_MEASURE_MAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_FACT_LEVEL_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_JOIN_KEY_COLUMN_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_LEVEL_KEY_COL_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_DIM_LEVEL_ATTR_MAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_CATALOGS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_ENTITY_DESC_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_CATALOG_ENTITY_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_FACT_TABLE_GID" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_HIER_CUSTOM_SORT" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAPMR_FACTTBLKEYMAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAPMR_FACTTBLFCTMAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_LISTDIMS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_DIM_HIERS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_HIERDIMS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_FACTTBLKEYMAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_RUFCTTBLKYMAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_FACTTBLFCTMAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_HIERDIM_KEYCOL_MAP" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAPMR_DIM_LEVELS_KEYMAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_DIM_LEVELS_KEYMAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_MR_MEASDIMVIEW" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP9I1_HIER_DIMENSIONS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP9I2_HIER_DIMENSIONS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP1_CUBES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_AWVIEWS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_AWVIEWCOLS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_AGGREGATION_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_ENTITY_PARAMETERS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_ENTITY_EXT_PARMS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_CUBES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_CUBE_MEASURES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_CUBE_DIM_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_CUBE_MEAS_DIM_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_DIMENSIONS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_DIM_HIERARCHIES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_DIM_LEVELS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_DIM_HIER_LEVEL_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_DIM_ATTRIBUTES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_DIM_ATTR_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_DIM_LEVEL_ATTRIBUTES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_CUBE_MEASURE_MAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_FACT_LEVEL_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_JOIN_KEY_COLUMN_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_LEVEL_KEY_COL_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_DIM_LEVEL_ATTR_MAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_CATALOGS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_ENTITY_DESC_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_CATALOG_ENTITY_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_FACT_TABLE_GID" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_HIER_CUSTOM_SORT" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAPMR_FACTTBLKEYMAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAPMR_FACTTBLFCTMAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_LISTDIMS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_DIM_HIERS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_HIERDIMS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_FACTTBLKEYMAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_RUFCTTBLKYMAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_FACTTBLFCTMAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_HIERDIM_KEYCOL_MAP" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAPMR_DIM_LEVELS_KEYMAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_DIM_LEVELS_KEYMAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_MR_MEASDIMVIEW" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP9I1_HIER_DIMENSIONS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP9I2_HIER_DIMENSIONS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP1_CUBES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_AWVIEWS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_AWVIEWCOLS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_AGGREGATION_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_ENTITY_PARAMETERS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBA_OLAP2_ENTITY_EXT_PARMS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_AW_LOAD_DIMENSIONS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_AW_LOAD_DIM_FILTERS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_AW_LOAD_CUBE_FILTERS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_AW_LOAD_CUBE_MEASURES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_AW_LOAD_DIM_PARMS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_AW_LOAD_CUBE_DIMS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_AW_LOAD_CUBES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_AW_LOAD_CUBE_PARMS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_MV_CUBE_AGG_MEASURES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_MV_CUBE_AGG_LEVELS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_LOAD_CUBE_SEGWIDTH" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_AW_CUBE_AGG_PLANS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_AW_CUBE_AGG_MEASURES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_AW_CUBE_AGG_LEVELS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_AW_CATALOGS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_AW_CATALOG_MEASURES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_AW_PHYS_OBJ" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_AW_PHYS_OBJ_PROP" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_AW_DIMENSIONS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_AW_ATTRIBUTES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_AW_CUBES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_AW_CUBE_DIM_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_AW_DIM_ENABLED_VIEWS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_AW_CUBE_ENABLED_VIEWS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_AW_CUBE_ENABLED_HIERCOMBO" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_AW_DIM_LEVELS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_AW_DIM_HIER_LVL_ORD" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_AW_CUBE_MEASURES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_AW_CUBE_AGG_SPECS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_AW_CUBE_AGG_MEAS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_AW_CUBE_AGG_LVL" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."ALL_OLAP2_AW_CUBE_AGG_OP" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP1_POP_DIMENSIONS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP1_POP_CUBES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_POP_DIMENSIONS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_POP_CUBES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AWVIEWS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AWVIEWCOLS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_CATALOGS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_CATALOG_ENTITY_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_LISTDIMS_CC" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_LISTDIMS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_DIM_HIERS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_HIERDIMS_CC" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_HIERDIMS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_DIM_HIER_LEVEL_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_JOIN_KEY_COL_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_DIM_ATTRIBUTES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_ENTITY_DESC_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_DESCRIPTORS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_DIM_LEVEL_ATTR_MAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_CUBE_MEASURES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_FACTTBLKEYMAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP1_FACTTBLKEYMAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_FACTTBLFCTMAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP1_FACTTBLFCTMAPS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_HIERDIM_KEYCOL_MAP" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_HIER_CUSTOM_SORT" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP_CWM1_AGGOP" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP_CWM1_AGGORD" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AGGREGATION_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_ENTITY_PARAMETERS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_ENTITY_EXT_PARMS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AWS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AW_MAP_DIM_USE" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AW_PHYS_OBJ" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AW_PHYS_OBJ_PROP" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AW_MAP_MEAS_USE" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AW_MAP_ATTR_USE" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AW_DIMENSIONS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AW_ATTRIBUTES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AW_CUBES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AW_CUBE_DIM_USES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AW_DIM_LEVELS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AW_CUBE_MEASURES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AW_CUBE_AGG_SPECS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AW_CUBE_AGG_MEAS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AW_CUBE_AGG_LVL" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AW_CUBE_AGG_OP" already exists 
ORA-31684: Object type SYNONYM:"PUBLIC"."MRV_OLAP2_AW_DIM_HIER_LVL_ORD" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_MR_SECURITY_INIT" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_MR_SESSION_POP" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_MR_CHECK_PRIVS" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_METADATA_REFRESH" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."OLAPFACTVIEW" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."OLAPDIMVIEW" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBMS_ODM" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."OLAP_SYS_AW_ACCESS_CUBE_VIEW" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."OLAP_SYS_AW_ACCESS_DIM_VIEW" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."OLAP_SYS_AW_ENABLE_ACCESS_VIEW" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_OLAPAPI_ENABLE" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."CWM2_OLAP_AW_AWUTIL" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBMS_AW_UTILITIES" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."DBMS_AWM" already exists
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
ORA-31684: Object type SYNONYM:"SYSTEM"."SYSCATALOG" already exists
ORA-31684: Object type SYNONYM:"SYSTEM"."CATALOG" already exists
ORA-31684: Object type SYNONYM:"SYSTEM"."TAB" already exists
ORA-31684: Object type SYNONYM:"SYSTEM"."COL" already exists
ORA-31684: Object type SYNONYM:"SYSTEM"."TABQUOTAS" already exists
ORA-31684: Object type SYNONYM:"SYSTEM"."SYSFILES" already exists
ORA-31684: Object type SYNONYM:"SYSTEM"."PUBLICSYN" already exists
ORA-31684: Object type SYNONYM:"SYSTEM"."PRODUCT_USER_PROFILE" already exists
ORA-31684: Object type SYNONYM:"OWBSYS_AUDIT"."WB_RT_HT_AUDIT_SEQUENCE" already exists
ORA-31684: Object type SYNONYM:"OWBSYS_AUDIT"."WB_RT_HT_AUDIT_JOB" already exists
ORA-31684: Object type SYNONYM:"OWBSYS_AUDIT"."WB_RT_HT_AUDIT_PHASE" already exists
ORA-31684: Object type SYNONYM:"OWBSYS_AUDIT"."WB_RT_HT_AUDIT_TASK" already exists
ORA-31684: Object type SYNONYM:"OWBSYS_AUDIT"."WB_RT_HT_AUDIT_STEP" already exists
ORA-31684: Object type SYNONYM:"OWBSYS_AUDIT"."WB_RT_HT_AUDIT_STRUCT" already exists
ORA-31684: Object type SYNONYM:"OWBSYS_AUDIT"."WB_RT_HT_AUDIT_ERROR" already exists
ORA-31684: Object type SYNONYM:"OWBSYS_AUDIT"."WB_RT_HT_AUDIT_ERROR_SOURCE" already exists
ORA-31684: Object type SYNONYM:"OWBSYS_AUDIT"."WB_RT_HT_AUDIT_TRACE" already exists
ORA-31684: Object type SYNONYM:"OWBSYS_AUDIT"."WB_RT_HT_AUDIT_FILE" already exists
ORA-31684: Object type SYNONYM:"OWBSYS_AUDIT"."WB_RT_HT_AUDIT_PARAM" already exists
ORA-31684: Object type SYNONYM:"OWBSYS_AUDIT"."WB_RT_HT_AUDIT_MSG" already exists
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
ORA-31684: Object type TYPE:"SYSTEM"."REPCAT$_OBJECT_NULL_VECTOR" already exists 
ORA-31684: Object type TYPE:"SYSTEM"."LOGMNR$TAB_GG_REC" already exists
ORA-31684: Object type TYPE:"SYSTEM"."LOGMNR$COL_GG_REC" already exists
ORA-31684: Object type TYPE:"SYSTEM"."LOGMNR$SEQ_GG_REC" already exists
ORA-31684: Object type TYPE:"SYSTEM"."LOGMNR$KEY_GG_REC" already exists
ORA-31684: Object type TYPE:"SYSTEM"."LOGMNR$TAB_GG_RECS" already exists
ORA-31684: Object type TYPE:"SYSTEM"."LOGMNR$COL_GG_RECS" already exists
ORA-31684: Object type TYPE:"SYSTEM"."LOGMNR$SEQ_GG_RECS" already exists
ORA-31684: Object type TYPE:"SYSTEM"."LOGMNR$KEY_GG_RECS" already exists
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM 
>>> Cannot set an SCN larger than the current SCN. If a Streams Capture configuration was imported then the Apply that processes the captured messages needs to be dropped and recreated. 
See My Oracle Support article number 1380295.1.
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ 
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM 
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE 
ORA-39151: Table "OUTLN"."OL$" exists. All dependent metadata and data will be skipped due to table_exists_action of skip 
ORA-39151: Table "OUTLN"."OL$NODES" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."DEF$_ERROR" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."DEF$_DESTINATION" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."DEF$_CALLDEST" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."DEF$_DEFAULTDEST" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."DEF$_PROPAGATOR" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."DEF$_ORIGIN" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."DEF$_PUSHED_TRANSACTIONS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_REPCAT" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_FLAVORS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_REPSCHEMA" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_SNAPGROUP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_REPOBJECT" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_REPCOLUMN" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_KEY_COLUMNS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_GENERATED" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_REPPROP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_REPCATLOG" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_DDL" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_REPGROUP_PRIVS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_PRIORITY_GROUP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_PRIORITY" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_COLUMN_GROUP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_GROUPED_COLUMN" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_CONFLICT" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_RESOLUTION_METHOD" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_RESOLUTION" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_RESOLUTION_STATISTICS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_RESOL_STATS_CONTROL" exists. All dependent metadata and data will be skipped due to table_exists_action of skip 
ORA-39151: Table "SYSTEM"."REPCAT$_PARAMETER_COLUMN" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_AUDIT_ATTRIBUTE" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_AUDIT_COLUMN" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_FLAVOR_OBJECTS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_TEMPLATE_STATUS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_TEMPLATE_TYPES" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_REFRESH_TEMPLATES" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_OBJECT_TYPES" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_OBJECT_PARMS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_TEMPLATE_SITES" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_SITE_OBJECTS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_TEMPLATE_TARGETS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_EXTENSION" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_SITES_NEW" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."SQLPLUS_PRODUCT_PROFILE" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_INTERNAL_TAGS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_DOC_TYPES" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_INSTALL_DOCS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_DOC_REFS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_VR_DT_MAP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_PRV_ATTRS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_DICT_ATTRS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_DAREFS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_MAPPED_PATHS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_ANON_RULE_TYPES" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_ANON_ACTION_TYPES" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_ANON_RULES" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_ANON_ATTRS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_RT_PREF_PARAMS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_UID_DEFS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip 
ORA-39151: Table "ORDDATA"."ORDDCM_STORED_TAGS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_DATA_MODEL" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_PRED" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_PRED_SET" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_MACRO_PAR" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_MACRO_DEP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_PRED_PAR" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_ACTION" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_LOCATORPATHS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_VLD_MSG" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_DOC_REFS_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_STD_ATTRS_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_PRV_ATTRS_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_DICT_ATTRS_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_DAREFS_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_MAPPED_PATHS_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_ANON_RULES_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_ANON_ATTRS_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_RT_PREF_PARAMS_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_UID_DEFS_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_STORED_TAGS_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_DATA_MODEL_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_PRED_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_PRED_SET_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_MACRO_PAR_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_MACRO_DEP_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_PRED_PAR_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_LOCATORPATHS_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_ACTION_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_STD_ATTRS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."MVIEW$_ADV_INDEX" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."MVIEW$_ADV_PARTITION" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "OWBSYS"."OWBRTPS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "OUTLN"."OL$HINTS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."OL$" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."OL$HINTS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."OL$NODES" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."DEF$_LOB" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_TEMPLATE_PARMS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_USER_PARM_VALUES" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_RUNTIME_PARMS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_EXCEPTIONS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."REPCAT$_INSTANTIATION_DDL" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."DEF$_AQCALL" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."DEF$_AQERROR" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_DOCS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_MAPPING_DOCS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_PREFS_LOOKUP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_PRED_OPRD" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_DOCS_TMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_STD_ATTRS_TMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_PRV_ATTRS_TMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_DICT_ATTRS_TMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_DOC_REFS_TMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_DAREFS_TMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_MAPPING_DOCS_TMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_MAPPED_PATHS_TMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_ANON_RULES_TMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_ANON_ATTRS_TMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_RT_PREF_PARAMS_TMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_UID_DEFS_TMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_STORED_TAGS_TMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_PRED_TMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_PRED_OPRD_TMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_PRED_SET_TMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_PRED_PAR_TMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_LOCATORPATHS_TMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_ACTION_TMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_DOCS_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_MAPPING_DOCS_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "ORDDATA"."ORDDCM_CT_PRED_OPRD_WRK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."MVIEW$_ADV_OWB" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. . imported "SUGI"."EXAMPLES"                           68.59 MB  500000 rows 
. . imported "SUGI"."EXAMPLES2"                          68.59 MB  500000 rows 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT 
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC 
ORA-31684: Object type PACKAGE:"SYSTEM"."DBMS_REPCAT_AUTH" already exists 
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION 
ORA-31684: Object type FUNCTION:"SYSTEM"."LOGMNR$COL_GG_TABF_PUBLIC" already exists 
ORA-31684: Object type FUNCTION:"SYSTEM"."LOGMNR$KEY_GG_TABF_PUBLIC" already exists
ORA-31684: Object type FUNCTION:"SYSTEM"."LOGMNR$SEQ_GG_TABF_PUBLIC" already exists
ORA-31684: Object type FUNCTION:"SYSTEM"."LOGMNR$TAB_GG_TABF_PUBLIC" already exists
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE 
ORA-31684: Object type PROCEDURE:"SYSTEM"."ORA$_SYS_REP_AUTH" already exists 
ORA-31684: Object type PROCEDURE:"OUTLN"."ORA$GRANT_SYS_SELECT" already exists
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION 
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS 
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW 
ORA-31684: Object type VIEW:"SYSTEM"."MVIEW_WORKLOAD" already exists 
ORA-31684: Object type VIEW:"SYSTEM"."MVIEW_FILTER" already exists
ORA-31684: Object type VIEW:"SYSTEM"."MVIEW_LOG" already exists
ORA-31684: Object type VIEW:"SYSTEM"."MVIEW_FILTERINSTANCE" already exists
ORA-31684: Object type VIEW:"SYSTEM"."MVIEW_RECOMMENDATIONS" already exists
ORA-31684: Object type VIEW:"SYSTEM"."MVIEW_EVALUATIONS" already exists
ORA-31684: Object type VIEW:"SYSTEM"."MVIEW_EXCEPTIONS" already exists
ORA-31684: Object type VIEW:"SYSTEM"."SCHEDULER_PROGRAM_ARGS" already exists
ORA-31684: Object type VIEW:"SYSTEM"."SCHEDULER_JOB_ARGS" already exists
ORA-31684: Object type VIEW:"SYSTEM"."AQ$DEF$_AQCALL" already exists
ORA-31684: Object type VIEW:"SYSTEM"."AQ$DEF$_AQERROR" already exists
ORA-31684: Object type VIEW:"SYSTEM"."PRODUCT_PRIVS" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_DOCUMENT_TYPES" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_DOCUMENTS" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_DBRELEASE_DOCS" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_CONSTRAINT_NAMES" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_DOCUMENT_REFS" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_DOCS_USR" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_DOC_REFS_USR" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_STD_ATTRS_USR" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_PRV_ATTRS_USR" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_DICT_ATTRS_USR" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_CT_DAREFS_USR" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_MAPPING_DOCS_USR" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_MAPPED_PATHS_USR" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_STORED_TAGS_USR" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_ANON_RULES_USR" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_ANON_ATTRS_USR" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_RT_PREF_PARAMS_USR" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_UID_DEFS_USR" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_USR" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_OPRD_USR" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_SET_USR" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_PAR_USR" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_CT_LOCATORPATHS_USR" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_CT_ACTION_USR" already exists
ORA-31684: Object type VIEW:"ORDDATA"."ORDDCM_CONFORMANCE_VLD_MSGS" already exists
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT 
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCUMENT_TYPES" already exists 
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CONFORMANCE_VLD_MSGS" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CONFORMANCE_VLD_MSGS" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_ACTION_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_ACTION_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_ACTION_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_ACTION_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_ACTION_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_ACTION_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_ACTION_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_ACTION_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_ACTION_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_ACTION_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_LOCATORPATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_LOCATORPATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_LOCATORPATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_LOCATORPATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_LOCATORPATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_LOCATORPATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_LOCATORPATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_LOCATORPATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_LOCATORPATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_LOCATORPATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_PAR_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_PAR_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_PAR_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_PAR_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_PAR_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_PAR_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_PAR_USR" already exists 
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_PAR_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_PAR_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_PAR_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_SET_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_SET_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_SET_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_SET_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_SET_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_SET_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_SET_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_SET_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_SET_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_SET_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_OPRD_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_OPRD_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_OPRD_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_OPRD_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_OPRD_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_OPRD_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_OPRD_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_OPRD_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_OPRD_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_OPRD_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_PRED_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_UID_DEFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_UID_DEFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_UID_DEFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_UID_DEFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_UID_DEFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_UID_DEFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_UID_DEFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_UID_DEFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_UID_DEFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_UID_DEFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_RT_PREF_PARAMS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_RT_PREF_PARAMS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_RT_PREF_PARAMS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_RT_PREF_PARAMS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_RT_PREF_PARAMS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_RT_PREF_PARAMS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_RT_PREF_PARAMS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_RT_PREF_PARAMS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_RT_PREF_PARAMS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_RT_PREF_PARAMS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_RULES_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_RULES_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_RULES_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_RULES_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_RULES_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_RULES_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_RULES_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_RULES_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_RULES_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_ANON_RULES_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STORED_TAGS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STORED_TAGS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STORED_TAGS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STORED_TAGS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STORED_TAGS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STORED_TAGS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STORED_TAGS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STORED_TAGS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STORED_TAGS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STORED_TAGS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPED_PATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPED_PATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPED_PATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPED_PATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPED_PATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPED_PATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPED_PATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPED_PATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPED_PATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPED_PATHS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPING_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPING_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPING_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPING_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPING_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPING_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPING_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPING_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPING_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_MAPPING_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_DAREFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_DAREFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_DAREFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_DAREFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_DAREFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_DAREFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_DAREFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_DAREFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_DAREFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CT_DAREFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DICT_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DICT_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DICT_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DICT_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DICT_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DICT_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DICT_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DICT_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DICT_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DICT_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_PRV_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_PRV_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_PRV_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_PRV_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_PRV_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_PRV_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_PRV_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_PRV_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_PRV_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_PRV_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STD_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STD_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STD_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STD_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STD_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STD_ATTRS_USR" already exists 
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STD_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STD_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STD_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_STD_ATTRS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOC_REFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOC_REFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOC_REFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOC_REFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOC_REFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOC_REFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOC_REFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOC_REFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOC_REFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOC_REFS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCS_USR" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCUMENT_REFS" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCUMENT_REFS" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCUMENT_REFS" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCUMENT_REFS" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCUMENT_REFS" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCUMENT_REFS" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCUMENT_REFS" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCUMENT_REFS" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCUMENT_REFS" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCUMENT_REFS" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCUMENT_REFS" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_CONSTRAINT_NAMES" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DBRELEASE_DOCS" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"ORDDATA" skipped, base object type VIEW:"ORDDATA"."ORDDCM_DOCUMENTS" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"SYSTEM" skipped, base object type VIEW:"SYSTEM"."SCHEDULER_PROGRAM_ARGS" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"SYSTEM" skipped, base object type VIEW:"SYSTEM"."SCHEDULER_JOB_ARGS" already exists
ORA-39111: Dependent object type OBJECT_GRANT:"SYSTEM" skipped, base object type VIEW:"SYSTEM"."PRODUCT_PRIVS" already exists
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT
ORA-39111: Dependent object type COMMENT skipped, base object type VIEW:"SYSTEM"."MVIEW_WORKLOAD" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type VIEW:"SYSTEM"."MVIEW_FILTER" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type VIEW:"SYSTEM"."MVIEW_LOG" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type VIEW:"SYSTEM"."MVIEW_FILTERINSTANCE" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type VIEW:"SYSTEM"."MVIEW_RECOMMENDATIONS" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type VIEW:"SYSTEM"."MVIEW_EVALUATIONS" already exists
ORA-39111: Dependent object type COMMENT skipped, base object type VIEW:"SYSTEM"."MVIEW_EXCEPTIONS" already exists
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY
ORA-31684: Object type PACKAGE_BODY:"SYSTEM"."DBMS_REPCAT_AUTH" already exists 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_TABLE_ACTION 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER 
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA 
Processing object type DATABASE_EXPORT/SCHEMA/PASSWORD_HISTORY 
Processing object type DATABASE_EXPORT/AUDIT 
Job "SYS"."SYS_IMPORT_FULL_01" completed with 820 error(s) at Sat Nov 23 16:34:59 2019 elapsed 0 00:01:39 

[oracle@client datapump]$  

データが Import されたか確認します。
データ移行先で、sugi ユーザーを作成していませんが、正常にsugi ユーザーで ログインできます。

[oracle@client datapump]$ sqlplus sugi/mIfoO8_fai12#gai897faosugi@destidb           

SQL*Plus: Release 11.2.0.4.0 Production on Sat Nov 23 16:41:53 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved. 


Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> 

10 件データ取得

SQL> SELECT * FROM EXAMPLES WHERE ROWNUM <= 10; 

        ID
----------
LABEL
--------------------------------------------------------------------------------
     SCORE       RATE BIRTHDAY
---------- ---------- ---------
       151
AMkeinTidEZboNbIGvVGlPXzMiGiGuulzgcfRBssmvaWtRiCRXGMSDWNuqMohNTdlCGFPUAsrvdegGCe
FNuZyQztWpTzPMWXxhcI
     72365  .68651474 19-MAR-09

       152
JTkqyKYsADHNfdTXIraFegWQpdGnRqxnZxlYIoruawhetftfoHhnSGLywreQAVgaAtmoSLRinIjYMQwe

略

データ件数も取得

SELECT COUNT(*) FROM EXAMPLES;
SELECT COUNT(*) FROM EXAMPLES2;

実行例
正常に 50万行ずつデータ移行が出来ています

SQL> SELECT COUNT(*) FROM EXAMPLES; 

  COUNT(*)
----------
    500000

SQL> SELECT COUNT(*) FROM EXAMPLES2; 

  COUNT(*)
----------
    500000

SQL> 

sugi スキーマ内の Object を確認します。TABLE 名は同じですが、INDEX 名は異なって Import されています

SQL> select object_name, object_type from dba_objects where owner='SUGI' order by object_name; 

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
EXAMPLES
TABLE

EXAMPLES2
TABLE

SYS_C005754
INDEX


OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
SYS_C005755
INDEX


SQL> 

参考URL

Oracle Data Pumpの概要
https://docs.oracle.com/cd/E16338_01/server.112/b56303/dp_overview.htm

Oracleで適当な件数のテストデータつくる
http://kagamihoge.hatenablog.com/entry/20130521/1369137719

オラクルデータ移行方法のまとめ
https://oracle-abc.wikidot.com/ja:data-transport-ja

DataPump(expdp/impdp)を使用したデータ移行手順
http://database090212.com/oracle/const5_5.html

Data Pump(expdp/impdp)の使い方~エクスポート/インポート、データ移動、論理バックアップ
https://blogs.oracle.com/oracle4engineer/data-pumpexpdpimpdp

コンパチビリティ
https://support.oracle.com/knowledge/Enterprise%20Management/2364786_1.html

Data Pump Quick Start
http://blogs.oracle.com/oracle4engineer/entry/oracle_data_pump_2

【セミナー動画/資料】意外と知らない!? Export/Importの基礎
https://blogs.oracle.com/oracle4engineer/exportimport-v2

Data Pump(expdp/impdp)とは
http://www.doppo1.net/oracle/utility/expdp_impdp.html

4
Help us understand the problem. What is going on with this article?
Why not register and get more from Qiita?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
sugimount
投稿している内容は個人的な見解なので、所属組織とは関係ありません

Comments

No comments
Sign up for free and join this conversation.
Sign Up
If you already have a Qiita account Login
4
Help us understand the problem. What is going on with this article?