hmmmm....gimana mau bantu kalo penjelasannya cuma "--> terjadi error"
On 5/23/07, agus purwanto <[EMAIL PROTECTED]> wrote: > > maaf pak, atas penulisan namanya. > > saya punya 2 server (pc sebenarnya) > server10g dan server9i > > trus saya export data saya dari 10g kemudian saya import ke 9i --> terjadi > error > trus saya copy kan file exp yg ada di server9i ke server10g --> terjadi > error > > seharusnya gimana ya pak? > > terima kasih, > ags > > ----- Original Message ---- > From: Andrew E.K. <[EMAIL PROTECTED] <endrue81%40yahoo.com>> > To: [email protected] <indo-oracle%40yahoogroups.com> > Sent: Wednesday, May 23, 2007 9:09:35 AM > Subject: Re: [indo-oracle] Import data dari 10g ke 9i > > Pak Agus, > > Nama saya masih Andrew loh :) > > Btw menambahkan dari Pak Yoel, bisa coba di sebutkan pak gimana commandnya > pas dicoba jalankan? and error nya jg. > Ini Databasenya 10g dan 9i ada di Server yang sama atau beda server? > > Andrew > > agus purwanto <purwanto_ags@ yahoo.com> wrote: salam, > > mas andhika saya coba kok tidak bisa ya, dia menyebutkan host does not > exists > kalo saya pake exp yg 10g tidak masalah > > tolong mas beritahu secara detail > > terima kasih, > ags > > ----- Original Message ---- > From: Andrew E.K. <[EMAIL PROTECTED] com> > To: indo-oracle@ yahoogroups. com > Sent: Tuesday, May 22, 2007 2:50:51 PM > Subject: Re: [indo-oracle] Import data dari 10g ke 9i > > Pak Agus, > > Iya pak exp database 10g dengan Exp utility yg 9i, lalu di import nanti > pakai 9i jg. > > Andrew > > agus purwanto <purwanto_ags@ yahoo.com> wrote: terima kasih atas > jawabannya pak andrew, > > maaf pak, bearti saya harus melakukan exp menggunakan versi 9 nya? > dan lakukan exp menggunak ver 9 di database yg 10 > > terima kasih, > ags > > ----- Original Message ---- > From: Andrew E.K. <[EMAIL PROTECTED] com> > To: indo-oracle@ yahoogroups. com > Sent: Tuesday, May 22, 2007 1:34:15 PM > Subject: Re: [indo-oracle] Import data dari 10g ke 9i > > Hi, > > Bisa coba dicek dari Matrix dibawah ini, ini saya ambil dari Metalink Note > 132904.1 : > > Matrix 2: Which EXPORT utility to use when importing into an Oracle8 > or a higher database release > (always use IMPORT utility of the target database): > > +----------- +-------- --------- --------- --------- --------- --------- > -----+ > | EXPORT | IMPORT into: | > | from +--------+-- ------+-- ------+-- ------+-- ------+-- ------+-- > ------+ > | \/ | 8.1.5 | 8.1.6 | 8.1.7 | 9.0.1 | 9.2.0 | 10.1.0 | 10.2.0 | > +----------- +-------- +-------- +-------- +-------- +-------- +-------- > +-------- + > | 5.x 1) 2)| EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | > | 6.x 2)| EXP6x | EXP6x | EXP6x | EXP6x | EXP6x | EXP6x | EXP6x | > | 7.x 3)| EXP7x | EXP7x | EXP7x | EXP7x | EXP7x | EXP7x | EXP7x | > +----------- +-------- +-------- +-------- +-------- +-------- +-------- > +-------- + > | 8.0.3 | EXP803 | EXP803 | EXP803 | EXP803 | EXP803 | EXP803 | EXP803 | > | 8.0.4 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | > | 8.0.5 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | > | 8.0.6 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | > +----------- +-------- +-------- +-------- +-------- +-------- +-------- > +-------- + > | 8.1.5 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | > | 8.1.6 | EXP815 | EXP816 | EXP816 | EXP816 | EXP816 | EXP816 | EXP816 | > | 8.1.7 | EXP815 | EXP816 | EXP817 | EXP817 | EXP817 | EXP817 | EXP817 | > +----------- +-------- +-------- +-------- +-------- +-------- +-------- > +-------- + > | 9.0.1 | N/S | EXP816 | EXP817 | EXP901 | EXP901 | EXP901 | EXP901 | > | 9.2.0 | N/S | N/S | EXP817 | EXP901 | EXP920 | EXP920 | EXP920 | > +----------- +-------- +-------- +-------- +-------- +-------- +-------- > +-------- + > | 10.1.0 4)| Not Supported | EXP817 | EXP901 | EXP920 | 4) | 4) | > | 10.2.0 4)| Not Supported | EXP817 | EXP901 | EXP920 | 4) | 4) | > +----------- +-------- +-------- +-------- +-------- +-------- +-------- > +-------- + > Jadi kalo mau ambil dump file dr 10g ke 9i ada caranya pak, pake exp > utility sesuai matrix diatas. Gak bisa pake export utility 10g, karena > downgrade version. Untuk import selalu pakai Import utility version database > targetnya. > Semoga membantu > > Andrew > > agus purwanto <purwanto_ags@ yahoo.com> wrote: salam, > > saya punya data dari database 10g, tetapi pada saat saya mau import > datanya menggunakan oracle database 9i terdapat error > > Import file: EXPDAT.DMP > x:\impdata.dmp > Enter insert buffer size (minimum is 8192) 30720> 8192 > IMP-00010: not a valid export file, header failed verification > IMP-00000: Import terminated unsuccessfully > > kenapa ya error tsb terjadi, adakah cara yg lain? > > salam, > ags > > ____________ _________ _________ _________ _________ _________ _Looking > for a deal? Find great prices on flights and hotels with Yahoo! FareChase. > http://farechase. yahoo.com/ > > [Non-text portions of this message have been removed] > > ------------ --------- --------- --- > > Real people. Real questions. Real answers. Share what you know. > > [Non-text portions of this message have been removed] > > ____________ _________ _________ _________ _________ _________ _ > Food fight? Enjoy some healthy debate > in the Yahoo! Answers Food & Drink Q&A. > http://answers. yahoo.com/ dir/?link= list&sid= 396545367 > > [Non-text portions of this message have been removed] > > ------------ --------- --------- --- > > Real people. Real questions. Real answers. Share what you know. > > [Non-text portions of this message have been removed] > > ____________ _________ _________ _________ _________ _________ _Shape > Yahoo! in your own image. Join our Network Research Panel today! > http://surveylink. yahoo.com/ gmrs/yahoo_ panel_invite. asp?a=7 > > [Non-text portions of this message have been removed] > > ------------ --------- --------- --- > Meet your soulmate! > Yahoo! Asia presents Meetic - where millions of singles gather > > [Non-text portions of this message have been removed] > > __________________________________________________________Get the Yahoo! > toolbar and be alerted to new email wherever you're surfing. > http://new.toolbar.yahoo.com/toolbar/features/mail/index.php > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
