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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: export with filesize option, dump file size estimation

Re: export with filesize option, dump file size estimation

From: JOE TESTA <JTESTA_at_longaberger.com>
Date: Wed, 19 Sep 2001 10:27:54 -0700
Message-ID: <F001.00392E06.20010919102531@fatcity.com>

why not take the size of the tablespaces with data(not indexes, u do have your indexes in separate tablespaces right?), divide by 1.9G and put that many filenames on the command line, you can't have too many, oracle wont use the extra but if you're short, you lose.
 
joe
>>> BChen_at_us.britannica.com 09/19/01 02:10PM
>>>

any idea on how to estimate the export dump file size without doing an actual export (not even to /dev/null)? <FONT face="Times New Roman">the idea is to use filesize option of export utility to export db to several files. i am aware
of using pipe/split to do large export. thanks, bill Received on Wed Sep 19 2001 - 12:27:54 CDT

Original text of this message

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