RE: 2GB OS LIMIT

> ----------
> From: Adi Murugaian[SMTP:adi_at_MarketingAssociates.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Monday, November 13, 2000 04:00
> To: Multiple recipients of list ORACLE-L
> Subject: RE: 2GB OS LIMIT
>
> Hi Oli,
>
> Thanks for your reply. I got the points, this is available in oracle 8i.
> Now I am trying this. Is there any way to do this in oracle 7 & 8
> database?
>

Send your export to a named pipe and start a process that will compress & split from that pipe :

mknod exp_pipe p
compress -c < exp_pipe | split -b 2048m - <name> &

set FILE = exp_pipe in your export parameter file.
>
> Is there any way to write the export file directly into 4mm tape?
>

Sure : set the FILE parameter to the name of the tape device : /dev/rmt ( or whatever )

> Thanks again.
> Adi.
>
>
> Hi,
> play around with the filesize and file-parameter of the export utility.
>
> oli
>
>
> On Monday 13 November 2000 01:44, adi_at_MarketingAssociates.com wrote:
>
> > > Hi,
> > I have few large tables which exceeds 2GB of export.dmp file.
> > How can I solve this issue.
> > I am trying to setup an automated process to export the entire database
> > everyday night for backup purpose.
> > To keep machine independent backup.
> >
> >
> > Environment:
> > ===========
> > Sun OS 2.6
> > Oracle 8.1.5
> >
> >
> > Thanks,
> > Adi.
> >
> >
> >
> > To: ORACLE-L_at_fatcity.com
>
> ----------------------------------------
Received on Mon Nov 13 2000 - 06:38:41 CST