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: 386

Filed under:

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

Related posts about Oracle