Getting error when using Oracle imp command to import dmp file
Posted
by
blizz
on Server Fault
See other posts from Server Fault
or by blizz
Published on 2012-10-05T03:23:24Z
Indexed on
2012/10/05
3:40 UTC
Read the original article
Hit count: 390
Oracle
I am importing a dmp file using the following command:
imp user/pass file=file.dmp log=logfile.log full=y ignore=y destroy=y
I get the following errors:
. . importing table "MESSAGE_BOARD"
IMP-00058: ORACLE error 22993 encountered
ORA-22993: specified input amount is greater than actual source amount
IMP-00028: partial import of previous table rolled back: 219638 rows rolled back
. . importing table "MESSAGE_BOARD_ARCHIVES"
IMP-00058: ORACLE error 22993 encountered
ORA-22993: specified input amount is greater than actual source amount
IMP-00028: partial import of previous table rolled back: 2477960 rows rolled back
I have tried increasing the tablespace size and adding a second datafile to no avail. I'm a total newb at Oracle so any help will be appreciated. Googled this for hours and still can't come up with a solution.
Thanks!
© Server Fault or respective owner