Hi Prayugi, Sama saja dengan process export, pada saat import anda harus menyertakan parameter FILESIZE dan nilainya harus sama dengan saat export.
contoh: imp FILESIZE=1M imp FILESIZE=1G Kadang kala pada saat exp oracle akan melakukan rounding pada nilai FILESIZE, lihat contoh: D:\>exp.exe user1/[EMAIL PROTECTED] file=orcl01.dmp owner=user1 filesize=7000 Export: Release 9.2.0.1.0 - Production on Tue Aug 1 11:20:11 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production EXP-00075: rounding FILESIZE down, new value is 6144 Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set Pada message "EXP-00075" terlihat exp melakukan rounding FILESIZE menjadi 6144, sehingga pada saat imp anda harus memasukan nilai FILESIZE=6144. sehingga akan menjadi: imp.exe FILESIZE=6144 Untuk process exp/imp yg memecah menjadi beberapa buah dumpfile, biasanya akan memaksa kita untuk memasukan nama dumpfile berikutnya. triks untuk meng-automatisasi process ini, sehingga process exp/imp bisa dapat terus berjalan tanpa kita tunggu. yaitu dengan cara mengcopy batch command ke dalam console/command prompt. contoh (copy perintah exp/imp berikut ke console/command prompt, saya mengasumsikan dumpfile yg terbentuk hanya 3 buah, tambahkan jika kurang) -- start copy and paste -- exp user1/[EMAIL PROTECTED] file=orcl01.dmp owner=user1 filesize=7000 orcl02.dmp orcl03.dmp -- end copy and paste -- dan contoh untuk importnya sbb: -- start copy and paste -- imp user1/[EMAIL PROTECTED] file=orcl01.dmp fromuser=user1 touser=user2 filesize=6144 orcl02.dmp orcl03.dmp -- end copy and paste -- Regards, Aply ----- Original Message ----- From: "Prayugi" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, August 01, 2006 09:58 AM Subject: Re: [indo-oracle] Re: EXPORT DATA > 2GB > thanks atas infonya > mo nanya lagi kalo file yang diexport displit jadi banyak > cara importnya gimana ? > > On 7/31/06, Dede Supriyatna <[EMAIL PROTECTED]> wrote: >> Dear Prayugi, >> Pada command exp terdapat parameter FILESIZE untuk menentukan ukuran >> dari dumpfile yg dibuat, jadi apabila melebihi nilai FILESIZE maka >> dumpfile akan di split menjadi beberapa file. >> >> misalkan: >> exp FILESIZE=1M >> exp FILESIZE=1G >> >> Regards, >> >> --- In [email protected], Prayugi <[EMAIL PROTECTED]> wrote: >> > >> > dear oracle mania, >> > >> > mohon pencerahannya bagaiamana caranya untuk export data yang >> > dmpnya sudah lebih dari 2gb, jadi mo dipecah-pecah filenya gitu >> > server pake : Oracle 9.0.1, OS Windows 2000 Advance Server (32 bit) >> > >> > salam >> > Prayugi >> > >> >> >> >> >> >> >> -- >> -----------I.N.D.O - O.R.A.C.L.E--------------- >> Keluar: [EMAIL PROTECTED] >> Website: http://indo-oracle.blogspot.com >> Mirror: http://indooracle.wordpress.com >> ----------------------------------------------- >> >> Bergabung dengan Indonesia Thin Client User Groups, >> Terminal Server, Citrix, New Moon Caneveral, di: >> http://indo-thin.blogspot.com >> Yahoo! Groups Links >> >> >> >> >> >> >> > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.blogspot.com > Mirror: http://indooracle.wordpress.com > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.blogspot.com > Yahoo! Groups Links > > > > > > > > > __________ NOD32 1.1685 (20060731) Information __________ > > This message was checked by NOD32 antivirus system. > http://www.eset.com > > ___________________________________________________________ All New Yahoo! Mail – Tired of [EMAIL PROTECTED]@! come-ons? Let our SpamGuard protect you. http://uk.docs.yahoo.com/nowyoucan.html -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
