Home » RDBMS Server » Server Utilities » Import Error
Import Error [message #307140] Mon, 17 March 2008 23:40 Go to next message
rakeshramm
Messages: 175
Registered: September 2006
Location: Oracle4u.com
Senior Member

When i importing ;triggers are not get imported how can i solve this
following is the output after my import


Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\user>IMP

Username: TEST/GLOVES@PRIMAS

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

Import file: EXPDAT.DMP > c:\orcl.dmp

Enter insert buffer size (minimum is 8192) 30720>

Export file created by EXPORT:V09.02.00 via conventional path

Warning: the objects were exported by PRIMAS, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no >

Ignore create error due to object existence (yes/no): no > Y

Import grants (yes/no): yes > Y

Import table data (yes/no): yes > Y

Import entire export file (yes/no): no > Y

. importing PRIMAS's objects into TEST
. . importing table "ATT_06_2007" 1 rows imported
. . importing table "ATT_09_2007" 1 rows imported
. . importing table "ATT_10_2007" 7 rows imported
. . importing table "ATT_11_2007" 1 rows imported
. . importing table "BRANCH_MAST" 2 rows imported
. . importing table "COMP_MAST" 2 rows imported
. . importing table "CONFIG_TABLE" 4 rows imported
. . importing table "EERE" 0 rows imported
. . importing table "ESI_CHALLAN_TABLE" 0 rows imported
. . importing table "FA_ACCOUNT_SETUP_GROUP_DTL" 8 rows imported
. . importing table "FA_ACCOUNT_SETUP_MAST" 5 rows imported
. . importing table "FA_ACCOUNT_SETUP_TAX_DTL" 29 rows imported

IMP-00008: unrecognized statement in the export file:
1
IMP-00008: unrecognized statement in the export file:
:
IMP-00008: unrecognized statement in the export file:
?
IMP-00008: unrecognized statement in the export file:
?
IMP-00008: unrecognized statement in the export file:
?
IMP-00008: unrecognized statement in the export file:

IMP-00017: following statement failed with ORACLE error 901:
"CREATE FORMAT92TRIG "
IMP-00003: ORACLE error 901 encountered
ORA-00901: invalid CREATE command
IMP-00008: unrecognized statement in the export file:
?
IMP-00008: unrecognized statement in the export file:
?
IMP-00008: unrecognized statement in the export file:
?
IMP-00008: unrecognized statement in the export file:
?
IMP-00008: unrecognized statement in the export file:
6
IMP-00008: unrecognized statement in the export file:
?
IMP-00008: unrecognized statement in the export file:
?
IMP-00008: unrecognized statement in the export file:
?
IMP-00008: unrecognized statement in the export file:

IMP-00017: following statement failed with ORACLE error 901:
"CREATE FORMAT92TRIG "
IMP-00003: ORACLE error 901 encountered
ORA-00901: invalid CREATE command
IMP-00008: unrecognized statement in the export file:

IMP-00008: unrecognized statement in the export file:
About to enable constraints...
Import terminated successfully with warnings.

[Updated on: Mon, 17 March 2008 23:44]

Report message to a moderator

Re: Import Error [message #307183 is a reply to message #307140] Tue, 18 March 2008 01:46 Go to previous message
Michel Cadot
Messages: 64108
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Seems you have (not exhaustive):
- transfert the file in wrong mode (not binary)
- a corrupt file
- export with a higher version than you import

Regards
Michel
Previous Topic: EXP vs EXPDP
Next Topic: IMPORT/EXPORT ISSUES
Goto Forum:
  


Current Time: Mon Dec 05 05:00:49 CST 2016

Total time taken to generate the page: 0.07794 seconds