From: Sukhjeet Singh (Sukhjeets@INVERA.COM)
Date: Fri Jan 24 2003 - 11:24:27 EST
the export file (in your situation) is a special file called a named pipe
which is created with the mknod command. It is used for interprocess
communications (your Oracle export command with the Unix split command).
The expaa, expab, expac are output from the split command, refer to the man
pages for more details.
Thanks,
Sukhjeet Singh.
-----Original Message-----
From: Leyden, Joseph [mailto:LeydenJ@MTA.NET]
Sent: Friday, January 24, 2003 11:01 AM
To: aix-l@Princeton.EDU
Subject: Re: mknod question
The exp worked and I noticed the 4 files but what is this:
prw-r--r-- 1 oracle sys 0 Jan 24 07:40 export
and why "expaa" as the first file,
and can I delete the file above if I import files individually?
------------------------------RESULTS---------------------------------------
--------------------------
-rw-r--r-- 1 oracle sys 1073741824 Jan 24 07:26 expaaa
-rw-r--r-- 1 oracle sys 1073741824 Jan 24 07:32 expaab
-rw-r--r-- 1 oracle sys 1073741824 Jan 24 07:38 expaac
-rw-r--r-- 1 oracle sys 206304815 Jan 24 07:40 expaad
prw-r--r-- 1 oracle sys 0 Jan 24 07:40 export
----------------------------------------------------------------------------
-------------------
-----Original Message-----
From: Sieger, Roland [mailto:Roland.Sieger@SUD-CHEMIE.COM]
Sent: Thursday, January 23, 2003 3:45 PM
To: aix-l@Princeton.EDU
Subject: AW: Export
how about :
mknod export p
exp file=export consistent=Y direct=Y full=y [ userid=<name>/<pasword>] |
split -b 1024m -a 3 export exp
will you give as many (up to 999 -a 3) files with 1024m
Mit freundlichen Grüßen
G.Roland Sieger, CIM
Email : roland.sieger@sud-chemie.com
Phone : (49) 89 5110 413
Fax : (49) 89 5110 532
Postanschrift :
Süd-Chemie AG
Lenbachplatz 6
80333 München
-----Ursprüngliche Nachricht-----
Von: Leyden, Joseph [mailto:LeydenJ@MTA.NET]
Gesendet: Donnerstag, 23. Januar 2003 23:50
An: aix-l@Princeton.EDU
Betreff: Re: Export
how do I exp(ort) over 2 gig size table using
Oracle 8.0.5 on AIX 4.3.2 RS6000
****************************************************************************
This e-mail may be privileged and/or confidential, and the sender does not
waive any related rights and obligations. Any distribution, use or copying
of this e-mail or the information it contains by other than an intended
recipient is unauthorized. If you received this e-mail in error, please
advise me (by return e-mail or otherwise) immediately.
Ce courriel est confidentiel et protégé. L'expéditeur ne renonce pas aux
droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou
copie de ce message ou des renseignements qu'il contient par une personne
autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez
ce courriel par erreur, veuillez m'en aviser immédiatement, par retour de
courriel ou par un autre moyen.
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:31 EDT