Re: DBMS DATAPUMP

From: Karthikeyan Panchanathan <keyantech_at_gmail.com>
Date: Fri, 16 Apr 2021 15:30:40 +0000
Message-ID: <SA0PR02MB74843A38B180193B661EA353FF4C9_at_SA0PR02MB7484.namprd02.prod.outlook.com>

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_at_gmail.com> Sent: Friday, April 16, 2021 8:56:10 AM
To: Karthikeyan Panchanathan <keyantech_at_gmail.com> Cc: Oracle L <oracle-l_at_freelists.org> 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_at_gmail.com<mailto:keyantech_at_gmail.com>> 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_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> on behalf of sumit Tyagi <dba.tyagisumit_at_gmail.com<mailto:dba.tyagisumit_at_gmail.com>> Sent: Friday, April 16, 2021 5:52:49 AM
To: Oracle L <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> 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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Apr 16 2021 - 17:30:40 CEST