Import Error [message #307140] |
Mon, 17 March 2008 23:40 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rakeshramm
Messages: 175 Registered: September 2006 Location: Oracle4u.com
|
Senior Member |
![rakeshramm@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|