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: 2GB OS LIMIT

RE: 2GB OS LIMIT

From: <ddorr.cs_at_clearstream.com>
Date: Tue, 14 Nov 2000 16:09:49 +0100
Message-Id: <10680.122024@fatcity.com>


> ----------
> From: TheOracle DBA[SMTP:theoracledba_at_lycos.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Monday, November 13, 2000 15:25
> To: Multiple recipients of list ORACLE-L
> Subject: RE: 2GB OS LIMIT
>
> Could I do this and make 1G files instead? (I like them smaller and no
> where near the OS limit).
>

Sure ! You can put whatever you want in the split options. ( man split )

> Can you give an exact example where the <name> is prodexp ?
>
> compress -c < exp_pipe | split -b 2048m - prodexp &
>

this will create files named prodexpaa, prodexpab, ...

> Cheers,
>
> Earl
>
>
>
> On Mon, 13 Nov 2000 04:45:40
> ddorr.cs wrote:
> >
> >
> >> ----------
> >> 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
> >>
> >> ----------------------------------------
> >>
> >>
> >>
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author:
> > INET: ddorr.cs_at_clearstream.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).
> >
>
>
> Get FREE Email/Voicemail with 15MB at Lycos Communications at
> http://comm.lycos.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: TheOracle DBA
> INET: theoracledba_at_lycos.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
Received on Tue Nov 14 2000 - 09:09:49 CST

Original text of this message

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