Dumpfiles in Expdp

General suggestions and comments about the forums.

Moderator: Tim...

Tanvi Agrawal
Posts: 5
Joined: Fri Oct 08, 2010 9:25 pm

Dumpfiles in Expdp

Postby Tanvi Agrawal » Sun Oct 10, 2010 9:37 pm

I m creating 2 dumpfiles in the location specified. One file is created of 9524 kb and other of 4 kb. Why is it so? I have not given any filesize.

C:\Documents and Settings\Tanvi>expdp system/test@db01 directory=data_pump_dir dumpfile=test1,admin_dir:test3 logfile=test3.log schemas=tanvi_test

Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Dumpfiles in Expdp

Postby Tim... » Tue Oct 12, 2010 1:23 pm


You have specified two files: test1 and test3


I would expect test1 to appear in the data_pump_dir, and test 3 to appear in the admin_dir.

As for the file size, notice the "minimum" file size in the documentation:

http://download.oracle.com/docs/cd/E118 ... m#i1006927

It probably formats the files to the minimum size even if nothign gets written to them.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://oracle-base.com
My blog: http://oracle-base.com/blog

Return to “Suggestions and Comments”

Who is online

Users browsing this forum: No registered users and 1 guest