はじめに
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 を選択します
Copy を押して、接続に必要な情報をコピーします
この 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 :
EXAMPLESEXAMPLES2 - INDEX :
SYS_c005728SYS_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