Network based schema impdp

From: Zwettler Markus (OIZ) <"Zwettler>
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-l


  • application/pkcs7-signature attachment: smime.p7s
Received on Fri Jul 08 2016 - 12:51:13 CEST

Original text of this message