Home » RDBMS Server » Server Utilities » Import Error (Oracle 10g)
Import Error [message #475517] Wed, 15 September 2010 07:27 Go to next message
rizwans
Messages: 5
Registered: September 2010
Location: Saudi arabia
Junior Member
Dear All,
I have exported data of one user an importing into another schema at another server.
when i am trying to imoport it is working fine for quite no of imports into tables, but after some time it starts giving me below mention error...

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:
+A
IMP-00008: unrecognized statement in the export file:


and inlast it is giving me this error and terminating my import.
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '303031303030303031'"
"; SREC.MAXVAL := '393939'; SREC.EAVS := 4; SREC.CHVALS := DBMS_STATS.CHARAR"
"RAY('001000001','003000004','003000012','003000015','003000018','003000020'"
",'003000021','003000023','003000030','003000042','003000056','003000077','0"
"03000096','003000101','003000108','003000114','003000127','003000139','0030"
"00150','003000166','003000172','003000189','003000200','003000217','0030002"
"43','003000275','005000015','005000030','005000043','005000056','005000065'"
",'005000075','005000086','005000103','005000117','005000138','005000156','0"
"05000185','005000214','005000249','005000282','005000321','005000368','0050"
"00410','005000446','005000473','005000490','005000509','005000529','0050005"
"49','005000566','005000582','005000599','005000613','005000633','005000656'"
",'005000672','005000693','005000710','005000725','005000743','005000761','0"
"05000780','005000802','005000820','005000841','005000857','005000874','0050"
"00889','005000910','005000931','005000948','005000972','005000993','0050010"
"14','005001032','005001050','005001070','005001089','005001115','005001133'"
",'005001160','005001184','005001213','005001235','005001261','005001292','0"
"05001324','005001350','005001371','005001400','005001428','005001458','0050"
"01491','005001526','005001560','005001600','005001639','005001684','0050017"
"34','005001778','005001810','005001837','005001871','005001896','005001928'"
",'005001963','005002001','005002036','005002069','005002091','005002126','0"
"05002162','005002192','005002230','005002266','005002304','005002340','0050"
"02378','005002415','005002445','005002483','005002519','005002556','0050025"
"92','005002622','005002654','005002689','005002724','005002757','005002790'"
",'005002823','005002859','005002892','005002928','005002966','005003001','0"
"05003040','008000002','050000001','1018','1057','1095','1131','1166','1200'"

"00,291827746154441000000000000000000000,29190863810836800000000000000000000"
"0,296979240509281000000000000000000000,297060132463208000000000000000000000"
",297121534289157000000000000000000000); SREC.BKVALS := DBMS_STATS.NUMARRAY("
"0,1,4,5,17,19,21,28,32,33,34,35,36,38,39,40,41,42,43,44,45,46,47,48,49,50,5"
"1,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,7"
"6,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,"
"101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119"
"29,230,231,2"
"32,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,"
"251,252,253,254); SREC.EPC := 230; DBMS_STATS.SET_COLUMN_STATS(NULL,'"PGITH"
"_POLICY"','"POLH_ASSR_CODE"', NULL ,NULL,NULL,6412,.000292214812299613,0,sr"
"ec,9,6); END;"
IMP-00003: ORACLE error 603 encountered
ORA-00603: ORACLE server session terminated by fatal error
IMP-00017: following statement failed with ORACLE error 3114:
"ALTER SESSION SET SKIP_UNUSABLE_INDEXES=FALSE"
IMP-00003: ORACLE error 3114 encountered
ORA-03114: not connected to ORACLE
IMP-00000: Import terminated unsuccessfully


Please help me in solving this issue.
Waiting for your valuable suggestion and solutions.

Regds
Re: Import Error [message #475520 is a reply to message #475517] Wed, 15 September 2010 07:50 Go to previous messageGo to next message
Littlefoot
Messages: 19680
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
another schema at another server

How did you transfer export file to another server? If it was FTP, did you use binary mode? (You should have).

Perhaps the export file is corrupted?
Re: Import Error [message #475563 is a reply to message #475517] Wed, 15 September 2010 13:16 Go to previous messageGo to next message
joy_division
Messages: 4527
Registered: February 2005
Location: East Coast USA
Senior Member
And what were the versions of the source and target databases and import and export utility?
Re: Import Error [message #475660 is a reply to message #475563] Thu, 16 September 2010 09:21 Go to previous messageGo to next message
rizwans
Messages: 5
Registered: September 2010
Location: Saudi arabia
Junior Member
Dear all,
Thanks for your update.
Both source and target database are of same version and i have copied the dmp file in my server (source) sharing folder and from their i have copied to my target system ( where i am trying to import ).
Actually i am trying to create the development server in my company for doing testing for which i was trining to export ( which was successfull) and later importing ( which i am getting problem).
Need your immediate help in this regard.
Thanks in advance.
Re: Import Error [message #475667 is a reply to message #475660] Thu, 16 September 2010 09:47 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
Senior Member
Since Oracle complains LOUDLY about problems during import, I can only conclude that target is different from source.
You have provided NO details to guess at what specifically might be causing the errors

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Import Error [message #475670 is a reply to message #475667] Thu, 16 September 2010 09:55 Go to previous messageGo to next message
rizwans
Messages: 5
Registered: September 2010
Location: Saudi arabia
Junior Member
Dear,
Thanks for your immediate response.
Dear, we at the end of every month we will take the export of our live database and import it into our development server.
this i was doing many times
But this time i am getting this kind of error. I am getting afraid of any data corruption in Live database.
Waiting for your immediate inputs.
Thanks in adwance.
Re: Import Error [message #475671 is a reply to message #475670] Thu, 16 September 2010 09:58 Go to previous message
BlackSwan
Messages: 22901
Registered: January 2009
Senior Member
>this i was doing many times
>But this time i am getting this kind of error. I am getting afraid of any data corruption in Live database.

We only know what you post.
Obviously something changed. Do any clues exist in alert_SID.log for either DB?
Previous Topic: EXP, EXPDP, IMP & IMPDP
Next Topic: Export Error
Goto Forum:
  


Current Time: Tue Oct 21 00:28:22 CDT 2014

Total time taken to generate the page: 0.15467 seconds