Pak Agus, Iya pak exp database 10g dengan Exp utility yg 9i, lalu di import nanti pakai 9i jg.
Andrew agus purwanto <[EMAIL PROTECTED]> 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]> To: [email protected] 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]
