Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Export
In article <hPL3iJAMv2b6EwMy_at_rees-chappell.demon.co.uk>,
James Chappell <james_at_rees-chappell.demon.co.uk> wrote:
> Is there a way of finding out how big an export dump file is likely to
> be before you begin the actual export (ie to find out if you've got
> enough space on your disc to store the file)?
>
> Thanks
> --
> James Chappell
>
If you keep indexes in separate tablespaces from tables a quick worse
case type test would be to sum the allocated bytes of storage in
sys.dba_extents for all table storage tablespaces. (Skipping system,
temp, rbs tablespaces, and index tablespaces). The exp will almost
surely not exceed this and will probably be much less since the Oracle
block overhead in not exported.
-- Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice -- Sent via Deja.com http://www.deja.com/Received on Wed Jan 24 2001 - 20:01:54 CST