Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiple Dump file

user480768Dec 4 2012 — edited Dec 11 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 8 2013
Added on Dec 4 2012
3 comments
605 views