From JTESTA@longaberger.com Wed, 19 Sep 2001 10:27:54 -0700 From: "JOE TESTA" Date: Wed, 19 Sep 2001 10:27:54 -0700 Subject: Re: export with filesize option, dump file size estimation Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@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)? 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