Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> IMPORT PROBLEM

IMPORT PROBLEM

From: harish <harishksh_at_yahoo.com>
Date: 24 Feb 2003 00:23:46 -0800
Message-ID: <ff46df6e.0302240023.703fb527@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US