RE: export size

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Thu, 7 Sep 2000 11:40:32 +0100
Message-Id: <10612.116385@fatcity.com>

How about this:

SQL> create or replace view TOTAL as
  2 select sum(bytes) TOTAL
  3 from DBA_EXTENTS
  4 where owner not like 'SYS%';

View created.

SQL> select * from total;

    TOTAL

---

 12347392

Or if you want to include sys:

SQL> create or replace view TOTAL as
  2 select sum(bytes) TOTAL
  3 from DBA_EXTENTS;

View created.

SQL> select * from total;

    TOTAL

---

 95399936

HTH Mark

-----Original Message-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of VERITE Nicolas BRX/FCR
Sent: 07 September 2000 10:30
To: Multiple recipients of list ORACLE-L Subject: export size

Hi you all !

How can I evaluate the size of an export ? Be it full or full without SYS* objects...

Thanx !
Nico

Nicolas VERITE - Univers Informatique - DBA Oracle Bureau: 01 42 21 77 80 - Mobile: 06 62 70 77 48

-- 
Author: VERITE Nicolas BRX/FCR
  INET: nicolas.verite_at_francetelecom.fr

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Sep 07 2000 - 05:40:32 CDT