RE: 2GB OS LIMIT

From: Naik, Kevin K <KNaik_at_mail.sbic.co.za>
Date: Tue, 14 Nov 2000 13:33:46 +0200
Message-Id: <10680.121979@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C04E2E.BFEB87C0
Content-Type: text/plain;

charset="iso-8859-1"

Adi,

Have you tried making use of operating system pipes ? id

/usr/sbin/mknod dumpfile.dmp
cat dumpfile.dmp |compress > final_file.dmp.Z & exp username/password file=dumpfile.dmp etc etc etc

to load:

zcat final_file.dmp.Z >dumpfile.dmp & imp username/password file=dumpfile.dmp etc etc

Kevin Naik
knaik_at_mail.sbic.co.za

-----Original Message-----
From: Adi Murugaian [ mailto:adi_at_MarketingAssociates.com
<mailto:adi_at_MarketingAssociates.com> ]

Sent: 13 November, 2000 02:45
To: Multiple recipients of list ORACLE-L Subject: 2GB OS LIMIT

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.

Disclaimer and confidentiality note

Everything in this e-mail and any attachments relating to the official business of Standard Bank Investment Corporation (Stanbic) is proprietary to the company. It is confidential, legally privileged and protected by law.\ Stanbic does not own and endorse any other content. Views and opinions are those of the sender unless clearly stated as being that of Stanbic.

The person addressed in the e-mail is the sole authorised recipient. Please notify the sender immediately if it has unintentionally reached you and do not read, disclose or use the content in any way.

Stanbic can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference.

------_=_NextPart_001_01C04E2E.BFEB87C0
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<TITLE>2GB OS LIMIT</TITLE>
<META content='"MSHTML 4.72.3110.7"' name=GENERATOR>
</HEAD>
<BODY>
<BLOCKQUOTE>

    <DIV><SPAN class=663071807-13112000><FONT color=#0000ff face=Tahoma     size=2>Adi,</FONT></SPAN></DIV>
    <DIV><SPAN class=663071807-13112000><FONT color=#0000ff face=Tahoma     size=2></FONT></SPAN> </DIV>
    <DIV><SPAN class=663071807-13112000><FONT color=#0000ff face=Tahoma     size=2>Have you tried making use of operating system pipes     ?</FONT></SPAN></DIV>
    <DIV><SPAN class=663071807-13112000><FONT color=#0000ff face=Tahoma     size=2></FONT></SPAN><SPAN class=663071807-13112000><FONT color=#0000ff     face=Tahoma size=2>id</FONT></SPAN></DIV>     <DIV><SPAN class=663071807-13112000><FONT color=#0000ff face=Tahoma     size=2></FONT></SPAN><SPAN class=663071807-13112000><FONT color=#0000ff     face=Tahoma size=2>    /usr/sbin/mknod     dumpfile.dmp</FONT></SPAN></DIV>
    <DIV><SPAN class=663071807-13112000><FONT color=#0000ff face=Tahoma     size=2></FONT></SPAN><SPAN class=663071807-13112000><FONT color=#0000ff     face=Tahoma size=2>    cat dumpfile.dmp |compress >     final_file.dmp.Z &</FONT></SPAN></DIV>     <DIV><SPAN class=663071807-13112000><FONT color=#0000ff face=Tahoma

    size=2></FONT></SPAN><SPAN class=663071807-13112000><FONT color=#0000ff 
    face=Tahoma size=2>&nbsp;&nbsp;&nbsp; exp username/password 
    file=dumpfile.dmp etc etc etc<SPAN class=415473511-14112000><FONT

color=#0000ff face=Tahoma size=2> </FONT></SPAN></FONT></SPAN></DIV> <DIV><SPAN class=663071807-13112000><FONT color=#0000ff face=Tahoma size=2><SPAN class=415473511-14112000><FONT color=#0000ff face=Tahoma size=2></FONT></SPAN></FONT></SPAN> </DIV> <DIV><SPAN class=663071807-13112000><FONT color=#0000ff face=Tahoma size=2><SPAN class=415473511-14112000><FONT color=#0000ff face=Tahoma size=2>to load:</FONT></SPAN></FONT></SPAN></DIV> <DIV><SPAN class=663071807-13112000><FONT color=#0000ff face=Tahoma size=2><SPAN class=415473511-14112000><FONT color=#0000ff face=Tahoma size=2>    zcat final_file.dmp.Z >dumpfile.dmp &</FONT></SPAN></FONT></SPAN></DIV> <DIV><SPAN class=663071807-13112000><FONT color=#0000ff face=Tahoma size=2><SPAN class=415473511-14112000><FONT color=#0000ff face=Tahoma size=2>    imp username/password file=dumpfile.dmp etc etc </FONT></SPAN></FONT></SPAN></DIV> <DIV><SPAN class=663071807-13112000><FONT color=#0000ff face=Tahoma size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=663071807-13112000><FONT color=#0000ff face=Tahoma size=2>Kevin Naik</FONT></SPAN></DIV> <DIV><SPAN class=663071807-13112000><FONT color=#0000ff face=Tahoma size=2></FONT></SPAN><SPAN class=663071807-13112000><FONT color=#0000ff face=Tahoma size=2>knaik_at_mail.sbic.co.za</FONT></SPAN></DIV> <BLOCKQUOTE>

        <DIV class=OutlookMessageHeader><FONT face="Times New Roman" 
        size=2>-----Original Message-----<BR><B>From:</B> Adi Murugaian [<A 
        href="mailto:adi_at_MarketingAssociates.com">mailto:adi_at_MarketingAssociates.com</A>]<BR><B>Sent:</B> 
        13 November, 2000 02:45<BR><B>To:</B> Multiple recipients of list 
        ORACLE-L<BR><B>Subject:</B> 2GB OS LIMIT<BR><BR></FONT></DIV>
        <P><FONT face="Times New Roman" size=2>Hi,</FONT><FONT 
        face="Times New Roman"> </FONT><BR><FONT face="Times New Roman" size=2>I 
        have few large tables which exceeds 2GB of export.dmp file.</FONT><FONT 
        face="Times New Roman"><BR></FONT><FONT face="Times New Roman" 
        size=2>How can I solve this issue.</FONT><FONT face="Times New Roman"> 
        </FONT><BR><FONT face="Times New Roman" size=2>I am trying to setup an 
        automated process to export the entire database everyday night for 
        backup purpose.</FONT><FONT face="Times New Roman"><BR></FONT><FONT 
        face="Times New Roman" size=2>To keep machine independent 
        backup.</FONT><FONT face="Times New Roman"> </FONT><BR></P>
        <P><FONT face="Times New Roman" size=2>Environment:</FONT><FONT 
        face="Times New Roman"><BR></FONT><FONT face="Times New Roman" 
        size=2>===========</FONT><FONT face="Times New Roman"><BR></FONT><FONT 
        face="Times New Roman" size=2>Sun OS 2.6</FONT><FONT 
        face="Times New Roman"><BR></FONT><FONT face="Times New Roman" 
        size=2>Oracle 8.1.5</FONT><FONT face="Times New Roman"> </FONT><BR></P>
        <P><FONT face="Times New Roman" size=2>Thanks,</FONT><FONT 
        face="Times New Roman"><BR></FONT><FONT face="Times New Roman" 
        size=2>Adi.</FONT><FONT face="Times New Roman">

</FONT></P></BLOCKQUOTE></BLOCKQUOTE>
<DIV>
<DIR><FONT color=#0000ff size=1>
<P>______________________________________________</FONT><FONT face=Arial size=1><B><FONT face=Arial
size=2></FONT></B></FONT></P>
<P><FONT face=Arial size=1><B><FONT face=Arial size=2>Disclaimer and
confidentiality note</B></FONT></FONT></P>
<P><FONT face=Arial size=1><FONT face=Arial size=2>Everything in this e-mail and
any attachments relating to the official business of Standard Bank Investment Corporation</FONT><FONT color=#0000ff face=Arial size=2> </FONT><FONT face=Arial size=2>(Stanbic) is proprietary to the company. It is confidential, legally privileged and protected by law. Stanbic</FONT><FONT color=#0000ff face=Arial size=2> </FONT><FONT face=Arial size=2>does not own and endorse any other content. Views and opinions are those of the sender unless clearly stated as being that of Stanbic. </FONT></FONT></P>
<P><FONT face=Arial size=1><FONT face=Arial size=2>The person addressed in the
e-mail is the sole authorised recipient. Please notify the sender immediately if it has unintentionally reached you and do not read, disclose or use the content in any way.</P>
<P align=justify></P>
<P>Stanbic can not assure that the integrity of this communication has been
maintained nor that it is free of errors, virus, interception or interference.</P></FONT></FONT><FONT color=#0000ff></DIR>
<P><FONT

size=1>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;_______________________________________________</FONT></P></FONT></DIV>

Received on Tue Nov 14 2000 - 05:33:46 CST