Network based schema impdp
Date: Fri, 8 Jul 2016 10:51:13 +0000
Message-ID: <65eede778c324929b9339e7152ebac20_at_SZHM22343.global.szh.loc>
Hi,
I found a procedure for a network based impdp. The procedure sets the actual (flashback) scn of the target system (see below).
That’s a mistake, isn’t it? What will impdp do with this invalid scn? Simply ignore it?
Cheers, Markus
procedure in target database:
...
...
h1 := dbms_datapump.open (operation => 'IMPORT', job_mode => 'SCHEMA', remote_link => l_link_name, version => 'COMPATIBLE'); <==<== remote network link
dbms_datapump.metadata_filter(handle => h1, name => 'SCHEMA_EXPR', value => 'LIKE ('''||substr(upper(l_owner),1,3)||'%'')');
dbms_datapump.metadata_filter(handle=> h1, name => 'EXCLUDE_PATH_EXPR', value => 'IN(''STATISTICS''
,''DB_LINK'' ,''USER'' ,''PROCEDURE'' ,''FUNCTION'' ,''PACKAGE_BODY'' ,''PACKAGE'' ,''REF_CONSTRAINT'')'); dbms_datapump.set_parameter(handle => h1, name => 'FLASHBACK_SCN', value => sys.dbms_flashback.get_system_change_number); <==<== set target scn ????????
dbms_datapump.set_parameter(handle => h1, name => 'TABLE_EXISTS_ACTION', value => 'TRUNCATE' );
dbms_datapump.start_job(handle => h1);
dbms_datapump.wait_for_job(handle => h1, job_state => v_job_state);
...
...
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 08 2016 - 12:51:13 CEST
- application/pkcs7-signature attachment: smime.p7s