Message-Id: <10680.121979@fatcity.com> From: "Naik, Kevin K" Date: Tue, 14 Nov 2000 13:33:46 +0200 Subject: RE: 2GB OS LIMIT 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@mail.sbic.co.za -----Original Message----- From: Adi Murugaian [ mailto:adi@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" 2GB OS LIMIT
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@mail.sbic.co.za
-----Original Message-----
From: Adi Murugaian [mailto:adi@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.

             _______________________________________________