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]> To: [email protected] 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]
