Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I import an old dump file into Oracle 10g? Can I use Original Import or do I have to convert to Data Pump Import?

April 26, 2017convert Data dump file import Oracle original pump

0

Posted

How do I import an old dump file into Oracle 10g? Can I use Original Import or do I have to convert to Data Pump Import?

1 Answer

0

Posted

Original Import will be maintained and shipped forever, so that Oracle Version 5.0 through Oracle9i dump files will be able to be loaded into Oracle 10g and later. Data Pump Import can only read Oracle Database 11g (and later) Data Pump Export dump files. Data Pump Import has new syntax and a new client executable, so Original Import scripts will need to change. Oracle recommends that customers convert to use the Oracle Data Pump Import.