Imp error [message #50285] |
Fri, 08 March 2002 13:34 |
jie gao
Messages: 6 Registered: March 2002
|
Junior Member |
|
|
I exported with EXP without warning. Then I tried to imp. Error occured when it got to a table. The error message is: IMP-00009: abnormal end of export file
IMP-00018: partial import of previous table completed: 686637 rows imported. I tried many times and it always stucked here. There I tried to exported that table and the tables follow, I had no problem to import those tables. What is wrong with it? That table has 686720 rows. It is almost done. What is wrong with it? Please help. Thanks.
Jie
|
|
|
Re: Imp error [message #50332 is a reply to message #50285] |
Mon, 11 March 2002 14:09 |
Andrew Lenz
Messages: 16 Registered: August 1999
|
Junior Member |
|
|
how big is the exp file? 2gig is the default max for the exp utility.
if you just want to copy this one tabel you can use the SQL plus copy command. copy tmp_t from db01 to db02, loggin to db02
set copycommit 5000;
copy from user/pass@db01 -
create tmp_t -
using -
select * from tmp_t;
|
|
|