This discussion is archived
3 Replies Latest reply: Dec 11, 2012 11:28 AM by user480768 RSS

Multiple Dump file

user480768 Newbie
Currently Being Moderated
I use SQL Developer 3.2 Data Pump -> Data Pump Export Wizard... to export one schema (ELLIPSE) into a dump file. However after the data pump export finish, I get multiple dump files as showing below. I plan to create only one dump file, it is about 2.6GB. Why does data pump Export Wizard create multiple dmp file sets? How do I use these dump files when I try to use data pump to import into database again? Thanks for your help.


Dump file set for SYSTEM.EXPORT_JOB_SQLDEV_263 is:
D:\ITINVENTORY\EXPELLIPSEDAT01-2012-12-04-11_58_51.DMP
D:\ITINVENTORY\EXPELLIPSEDAT02-2012-12-04-11_58_51.DMP
D:\ITINVENTORY\EXPELLIPSEDAT03-2012-12-04-11_58_51.DMP
D:\ITINVENTORY\EXPELLIPSEDAT04-2012-12-04-11_58_51.DMP
D:\ITINVENTORY\EXPELLIPSEDAT05-2012-12-04-11_58_51.DMP
D:\ITINVENTORY\EXPELLIPSEDAT06-2012-12-04-11_58_51.DMP
D:\ITINVENTORY\EXPELLIPSEDAT07-2012-12-04-11_58_51.DMP
D:\ITINVENTORY\EXPELLIPSEDAT08-2012-12-04-11_58_51.DMP
D:\ITINVENTORY\EXPELLIPSEDAT09-2012-12-04-11_58_51.DMP
D:\ITINVENTORY\EXPELLIPSEDAT10-2012-12-04-11_58_51.DMP
D:\ITINVENTORY\EXPELLIPSEDAT11-2012-12-04-11_58_51.DMP
D:\ITINVENTORY\EXPELLIPSEDAT12-2012-12-04-11_58_51.DMP
D:\ITINVENTORY\EXPELLIPSEDAT13-2012-12-04-11_58_51.DMP
D:\ITINVENTORY\EXPELLIPSEDAT14-2012-12-04-11_58_51.DMP
D:\ITINVENTORY\EXPELLIPSEDAT15-2012-12-04-11_58_51.DMP
D:\ITINVENTORY\EXPELLIPSEDAT16-2012-12-04-11_58_51.DMP
D:\ITINVENTORY\EXPELLIPSEDAT17-2012-12-04-11_58_51.DMP
D:\ITINVENTORY\EXPELLIPSEDAT18-2012-12-04-11_58_51.DMP
D:\ITINVENTORY\EXPELLIPSEDAT19-2012-12-04-11_58_51.DMP
D:\ITINVENTORY\EXPELLIPSEDAT20-2012-12-04-11_58_51.DMP
Job "SYSTEM"."EXPORT_JOB_SQLDEV_263" successfully completed at 12:03:10

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points