Home » RDBMS Server » Server Utilities » how to expdp to find out the table size/row without the data
how to expdp to find out the table size/row without the data [message #426365] Thu, 15 October 2009 02:40 Go to next message
win3vin
Messages: 35
Registered: April 2007
Location: Malaysia
Member
Hi,

I'm having a oracle 10gr2 version, when i perform a full database backup using below command, i got the size and row.


expdp test /test_dev2009 DIRECTORY=expdp_dir logfile=estimate.log schemas=testing

How do i export without the data but only to get the size and row of the table?

tried to use estimate_only but the size not accurate.

Re: how to expdp to find out the table size/row without the data [message #426373 is a reply to message #426365] Thu, 15 October 2009 03:09 Go to previous message
balakrishnay
Messages: 54
Registered: September 2009
Location: Pune
Member

hi,

For clear explanation and for better understanding go through this document(786165.1).

Regards

Bala
Previous Topic: EXPDP errors
Next Topic: Error while Exporting data
Goto Forum:
  


Current Time: Sat Oct 01 14:28:26 CDT 2016

Total time taken to generate the page: 0.08666 seconds