Migrating a Recovery Catalog is not easy with datapump

How to transfer data over network links:
Preparation:

connect sys@oemrepo as sysdba
create tablespace rcat datafile 1000m ;
create user rcat identified by xxx default tablespace rcat quota unlimited on rcat ;
grant recovery_catalog_owner to rcat ;
create public database link rcat connect to system identified by xxx using 'RCAT' ;

impdp job:
impdp rcat@oemrepo directory=dp_dir logfile=impdp.log network_link=RCAT table_exists_action=replace schemas=rcat flashback_time=systimestamp exclude=statistics

First problem:
ORA-39113 When Running A DataPump Job Through NETWORK_LINK (Doc ID 2100177.1)
– you have to create a public database link
Second problem:
ORA-39181: Only partial table data may be exported due to fine grain access control on “RCAT”.”BP”
. . imported “RCAT”.”BP” 565783 rows
– even when I grant grant exempt access policy to system ; it throws these errors
Third Problem:
There is a table with LONG column and that’s not supported by Oracle

Well, it looks like I have to read how to do it correctly because I become sad mad and I found this: https://docs.oracle.com/database/121/BRADV/rcmcatdb.htm#BRADV189
https://docs.oracle.com/database/121/RCMRF/rcmsynta026.htm#RCMRF198

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s