From: Sieger, Roland (Roland.Sieger@SUD-CHEMIE.COM)
Date: Thu Jan 23 2003 - 19:08:36 EST
not to mention :
you import that stuff with (as example, as was teh prev. mail ) with
mknod pipe p
cat exp* > pipe &
imp <userid/password> file=pipe buffer=1048576 [ fromuser=<userid>
touser=<userid> ] log=imp.log
that is basically it . you have to ajust it to your actual needs.
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: Freitag, 24. Januar 2003 00:54
An: aix-l@Princeton.EDU
Betreff: Re: Export
hmm, very interesting ... as you can tell I'm not a unix expert
thanks! I'll try it and read about mknod.
-----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 archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:31 EDT