Originally posted by OracleDoc
Hee hee good call Stmotgo.. 20 gig tablespace with only 200 meg used. tell me you haven't seen that before?!
or maybe a 8gb database that fits into a 116m dump file......?


SQL> select sum(bytes/1024/1024/1024) GB from v$datafile;

GB
----------
7.97167969

host exp system/manager file=c:\temp\myexport.dmp full=y
.
.
.
Export terminated successfully without warnings.

SQL> host dir c:\temp\*.dmp
Volume in drive C has no label.
Volume Serial Number is 9C16-6AC4

Directory of c:\temp

09/28/2003 11:11 PM 122,112,000 myexport.dmp
1 File(s) 122,112,000 bytes
0 Dir(s) 13,340,061,696 bytes free

SQL>