Re: Exporting directly to tape on HP-UX 10.x
From: Thomas M. Buccelli <tmb_at_idm.com>
Date: 1996/02/12
Message-ID: <DMn3Cq.4tE_at_idm.com>#1/1
} > One of our DBA's is trying to export a large database directly to tape,
} > and is having trouble doing it automatically from a shell script (for
} > eventual use in a cron job).
Date: 1996/02/12
Message-ID: <DMn3Cq.4tE_at_idm.com>#1/1
John Verhoeven (johnv_at_acix.DIALix.oz.au) wrote:
} In article dated Thu, 08 Feb 1996 11:38:20 -0500, Brian M. Biggs (bbiggs_at_cincom.com) wrote:
} > One of our DBA's is trying to export a large database directly to tape,
} > and is having trouble doing it automatically from a shell script (for
} > eventual use in a cron job).
} > Volume size (<ret> for no restriction) >
} I created a file called answer with just a carriage return (CR) in it. I did } my export with 'exp .... < answer' and it took the CR as the answer to the } question and went on its merry way.
} No doubt somebody else will have a better answer...but it worked.
I don't know what version of Oracle you are using, but in ver6 on HPUX9 I just use the volsize=0 command line option. Type 'exp help=Y' for more.
Tom
-- Thomas M. Buccelli (tmb_at_idm.com) #include <std_disclaimer.h>Received on Mon Feb 12 1996 - 00:00:00 CET