Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> IMPORT PROBLEM
i am having windows NT version 4.0 as OS and oracle 7.3 as the
database.
i am having a table which has around 20 attributes and 12500 rows.
before adding some 200 rows to this table i was able to export and
import this table properly.
but after adding around 200 rows it is getting exported successfully
but while importing, it is giving a series of
"Imp-00008 unrecognised statement in the export file" error follwed by
some table data.
(i am issuing this import statement:
"imp73 username/password fromuser=from_user touser=to_user
file=export_file.dmp ignore=y")
after giving these statements and data it is ending it's import
abruptly without giving the statement
"Import terminated successfully".
This import problem is happening irrespective of Operating system and
oracle version that is on all PCs it is not importing this table
properly.
when i visited the site tahiti.oracle.com to find the solution for this error message i got the following answer IMP-00008 unrecognized statement in the export file: string
Cause: Import did not recognize a statement in the export file. Either the export file was corrupted, or an Import internal error has occurred.
Action: If the export file was corrupted, retry with a new export file. Otherwise, report this as an Import internal error and submit the export file to Oracle Customer Support.
please give some solution. Received on Mon Feb 24 2003 - 02:23:46 CST
![]() |
![]() |