DBMS_DATAPUMP (Multiple Schemas) - need some suggestions for the parameter
Date: Tue, 5 Mar 2019 10:43:11 -0600
Message-ID: <CAP79kiSer8FmtKc=ss4HO3t0Q=EBQt6dELJBV8ComqsSsZzqew_at_mail.gmail.com>
env: 12.1.0.2
I'm trying to export multiple schemas using DBMS_DATAPUMP and have run into a bit of a conundrum.
This line only accepts on schema at a time: So as long as my loop only contains one schema, it works
DBMS_DATAPUMP.metadata_filter ( handle => h1, name => 'SCHEMA_EXPR', VALUE => 'IN(''' || rec.username || ''')');
This line "appears" to work better but actually doesn't import anything unless there's only one schema in the loop.
dbms_datapump.metadata_filter(h1, 'SCHEMA_LIST', ''''||rec.username||'''');
So, how can I add multiple schemas via Loop ? I've been putzing with this for several hours now and hitting a brick wall on this.
There will be about 10 schemas and I want the loop to be able to be dynamic if possible. The export is coming from a source code database so the data size is going to be small and will be used by developers running docker images.
I've got it working great for 1 schema - but I'd like to build it where it can handle doing all the schemas at once.
Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 05 2019 - 17:43:11 CET