Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> database space and export file size ?

database space and export file size ?

From: cc <zhangc_at_netcom.ca>
Date: 2000/07/19
Message-ID: <j0ud5.32383$qS3.68105@tor-nn1.netcom.ca>#1/1 






Oracle 7.3.4 on Unix



I use "select sum(bytes) from user_segments where owner='JOHN'" and the
result is about 3GB.



But use export owner=JOHN, the dump file only 800MB. Even full=y the dump
file is only about 1.2GB. Why is so different? Is there anyway can tell
roughly what the export dump file size will be?



Thanks


Chuck
Received on Wed Jul 19 2000 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US