RE: exp a big tablespace

If using 8i, consider using file= and filesize= parameter to let exp split the file for you. This operation is supported by Oracle :) Here is an example:
 exp file=/u01/export/f1.dmp, /u02/export/f2.dmp, /u03/export/f3.dmp filesize=2000m <other options as required>  Exp will create up to 3 files with max size of 2GB each. You have to make sure that you have specified enough number of files and there is enough space in the filesystem. It exp runs out of specified files, it will hang waiting for you to input the file name to continue exporting. But it will abort if no space is left in the FS.

And here is how to import from these files:  imp file=/u01/export/f1.dmp, /u02/export/f2.dmp, /u03/export/f3.dmp <other options as required>
 The thing to remember is that the file= for imp must use the same sequence of file names used in the export. Else it will abort with imp-00047 error but will tell you what file goes first.

HTH,

• Kirti

> -----Original Message-----
> From: Scott Shafer [SMTP:sknd100_at_yahoo.com]
> Sent: Tuesday, November 20, 2001 3:27 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: exp a big tablespace
>
> BEWARE! There are some versions of the split command that only work
> with ASCII character files. Make sure your version works with binaries
> as well.
>
> --Scott
>
>
> > "Aponte, Tony" wrote:
> >
> > Here's a tip I mined many moons ago from I don't know where. It's a
> > script to split the compressed file into smaller chunks using the
> > standard UNIX split utility.
> >
> > HTH
> > Tony Aponte
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

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).