thanks banget buat pencerahannya salam Prayugi
On 8/1/06, aply <[EMAIL PROTECTED]> wrote: > 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 > > > > > > > -- -----------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/
