RE: 2GB OS LIMIT

Could I do this and make 1G files instead? (I like them smaller and no where near the OS limit).

Can you give an exact example where the <name> is prodexp ?

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).
>
Received on Mon Nov 13 2000 - 08:23:58 CST