Hi Friends,
I got this error IMP-20 when importing a table
from export file. I do not have a long
columns on my table and increasing buffer size
does not work also.
O.S. AIX 4.3.3
Oracle 8.1.6
Help me please...
Thank you all
Printable View
Hi Friends,
I got this error IMP-20 when importing a table
from export file. I do not have a long
columns on my table and increasing buffer size
does not work also.
O.S. AIX 4.3.3
Oracle 8.1.6
Help me please...
Thank you all
1) are us trying to import on the same server ?
if u are trying on other server
just check if u have transferred the file in binary format .
th eexport dump might have corrupted .
2) if the above situation is OK then just try importing
with diffrent combinations of the following parameters .
recordlength=655360 or commit=Y and don't set buffer parameter in ur par file .
Hi Friend,
I'm importing on the same server. I also tried to import show=y
to browse all the constents of the file and its ok. Only one
table was affected.
I also tried commit=y and recordlength=655360 but the error
prevails. Any other suggestions pls?
Thanks