Dumpfiles in Expdp

General suggestions and comments about the forums.

Moderator: Tim...

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
Tanvi Agrawal
Member
 
Posts: 5
Joined: Fri Oct 08, 2010 9:25 pm

Re: Dumpfiles in Expdp

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

Hi.

You have specified two files: test1 and test3

dumpfile=test1,admin_dir: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.

Cheers

Tim...
Tim...
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://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17953
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Suggestions and Comments

Who is online

Users browsing this forum: No registered users and 1 guest

cron