Re: IMPORT PROBLEM

From: Dale Edgar <Dale_at_DataBee.com>
Date: Mon, 24 Feb 2003 08:40:57 +0000 (UTC)
Message-ID: <3e59d9f9.81865276@news.btclick.com>

Are you sure you are not exporting from a higher Oracle version than you are trying to import into?

Regards
-Dale

---

Need to document your database structure? Use the freeware DDL to HTML converter in the DBATool. http://www.DataBee.com/dt_home.htm

On 24 Feb 2003 00:23:46 -0800, harishksh_at_yahoo.com (harish) wrote:

>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:40:57 CST