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.

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 12:52:05 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.