11-02-09, 10:50 #1Registered User
- Join Date
- Aug 2009
Unanswered: IMP-00008: unrecognized statement in the export file:
I have taken export on the oracle 10.2.0.1.0
Operation System is Windows XP professional Verison 2002 Service pack 2
exp cobra/cobra statistics=none FILE=d:\db\cobra_new.dmp LOG=d:\db\logs.log
export is starting with
Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
Export and ends with
Export terminated successfully without warnings.
For Import environment is as
Version is Oracle Database 10g Release 10.1.0.2.0 - Production
Operating system Windows Server 2003 Enterprise Edition
For import it was giving error so I have takes all tables script from
source database and created all the tables in the destination database.
Now I am trying to import with following command
imp cobra/cobra FROMUSER=cobra TOUSER=cobra FILE=d:\sandeep\cobra_new.dmp LOG=d:\sandeep\logs.log statistics=none ignore=Y
On importing following error message
Connected to: Oracle Database 10g Release 10.1.0.2.0 - Production
Export file created by EXPORT:V10.02.01 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
IMP-00008: unrecognized statement in the export file:
In import not all the data gets import.
I am not able to understand what to do.
Thanks and Regards,
11-02-09, 11:13 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
Oracle does not allow exp from higher version (V10.2) & then imp into lower (V10.1) version.
If V10.1 imp is to be used, then V10.1 exp must be first used.You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.
11-02-09, 11:51 #3Registered User
- Join Date
- Dec 2003
If you instead go with expdp (Export DataPump), then you can export from a more recent version into an earlier version. To do so, you need to perform the export using the VERSION parameter, specifying the version of the database that you want to impdp into.
You should move away from exp to expdp anyway, if you're now dealing with version 10+. It offers performance advantages.