OraFAQ Forum: Server Utilities » Getting to know size of tables from Dump?

Home » RDBMS Server » Server Utilities » Getting to know size of tables from Dump?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Getting to know size of tables from Dump? [message #198968]

Thu, 19 October 2006 07:50

msgforsunil
Messages: 26
Registered: November 2005

Junior Member

Hi All,

Is there any way to identify how much size an oracle dump would take on the disk without actually importing it?

Thanks
Sunil Kumar

Report message to a moderator

Re: Getting to know size of tables from Dump? [message #198987 is a reply to message #198968]

Thu, 19 October 2006 09:14

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I do not understand what you are asking.
you mean,
estimate table size before importing from dump
or
Dumpfile size before exporting/dumping from Oracle to OS?

Report message to a moderator

Re: Getting to know size of tables from Dump? [message #199216 is a reply to message #198968]

Sat, 21 October 2006 11:59

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

SQL> host expdp scott/tiger directory=data dumpfile=data.dmp tables=emp estimate
=blocks

Export: Release 10.1.0.2.0 - Production on Saturday, 21 October, 2006 20:54

Copyright (c) 2003, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Starting "SCOTT"."SYS_EXPORT_TABLE_01":  scott/******** directory=data dumpfile=
data.dmp tables=emp estimate=blocks
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TBL_TABLE_DATA/TABLE/TABLE_DATA
.  estimated "SCOTT"."EMP"                                  64 KB
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
. . exported "SCOTT"."EMP"                               7.820 KB      14 rows
Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
  C:\DATA.DMP
Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 20:55

You can find out size before export but for import check dump file.

Report message to a moderator

Re: Getting to know size of tables from Dump? [message #199255 is a reply to message #199216]

Sun, 22 October 2006 22:37

msgforsunil
Messages: 26
Registered: November 2005

Junior Member

Yes, estimate table size before importing from dump.

Report message to a moderator

Previous Topic:	Import dmp file from server to another server
Next Topic:	Space utilisation for number.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 23:26:57 CST 2024