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 <[EMAIL PROTECTED]> 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]
