Home » RDBMS Server » Server Utilities » Size of a .dmp file
Size of a .dmp file [message #71413] Wed, 30 October 2002 12:46 Go to next message
AT
Messages: 14
Registered: July 1999
Junior Member
What factors make a .dmp file large?? I have an instance with only 48 tables, the largest having 3Million rows.

Would that produce a .dmp file thats 500MB??

Report message to a moderator

Re: Size of a .dmp file [message #71414 is a reply to message #71413] Wed, 30 October 2002 12:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
The size dump file is little affected by data in the database. IT is the extents the table has occupied that scores.

Report message to a moderator

Re: Size of a .dmp file [message #71431 is a reply to message #71413] Thu, 31 October 2002 15:28 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
It depends on the number of rows exported and the size of each row in bytes. Multiply the numbers and you will get very close estimation.

To get the exact size, use the method described in This Article

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: where is my table ,my data
Next Topic: Creation of win2k services
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 14 09:31:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.