Home » RDBMS Server » Server Utilities » Getting to know size of tables from Dump?
Getting to know size of tables from Dump? [message #198968] Thu, 19 October 2006 07:50 Go to next message
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
Re: Getting to know size of tables from Dump? [message #198987 is a reply to message #198968] Thu, 19 October 2006 09:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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?
Re: Getting to know size of tables from Dump? [message #199216 is a reply to message #198968] Sat, 21 October 2006 11:59 Go to previous messageGo to next message
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.

Re: Getting to know size of tables from Dump? [message #199255 is a reply to message #199216] Sun, 22 October 2006 22:37 Go to previous message
msgforsunil
Messages: 26
Registered: November 2005
Junior Member
Yes, estimate table size before importing from dump.
Previous Topic: Import dmp file from server to another server
Next Topic: Space utilisation for number.
Goto Forum:
  


Current Time: Thu Dec 08 16:23:30 CST 2016

Total time taken to generate the page: 0.05926 seconds