That’s correct. We can save in table user input and construct as dynamic sql.
Get Outlook for iOS<https://aka.ms/o0ukef>
________________________________
From: sumit Tyagi <dba.tyagisumit@xxxxxxxxx>
Sent: Friday, April 16, 2021 8:56:10 AM
To: Karthikeyan Panchanathan <keyantech@xxxxxxxxx>
Cc: Oracle L <oracle-l@xxxxxxxxxxxxx>
Subject: Re: DBMS DATAPUMP
Hi Karthikeyan
So in that case whatever parameters user choose we will have to dynamically
construct the PL-SQL block and submit it on the database correct .
On Fri, 16 Apr 2021 at 5:21 PM, Karthikeyan Panchanathan
<keyantech@xxxxxxxxx<mailto:keyantech@xxxxxxxxx>> wrote:
Hi Sumit
Yes we can use with same parameters as we define in PAR on Server but you have
to construct (or) read from table where you keep all these as data.
HTH
Karth
Get Outlook for iOS<https://aka.ms/o0ukef>
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
<oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>> on behalf
of sumit Tyagi <dba.tyagisumit@xxxxxxxxx<mailto:dba.tyagisumit@xxxxxxxxx>>
Sent: Friday, April 16, 2021 5:52:49 AM
To: Oracle L <oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>>
Subject: DBMS DATAPUMP
Hi Oracle L Team,
One query : Can DBMS Datapump package be used for parameter file for export
import .
BR
Sumit
--
--
BR
Sumit Kumar Tyagi
+91-7829543355
--
--
BR
Sumit Kumar Tyagi
+91-7829543355