OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Import Error (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import Error [message #475517]

Wed, 15 September 2010 07:27

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

Report message to a moderator

Re: Import Error [message #475520 is a reply to message #475517]

Wed, 15 September 2010 07:50

Littlefoot
Messages: 21808
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?

Report message to a moderator

Re: Import Error [message #475563 is a reply to message #475517]

Wed, 15 September 2010 13:16

joy_division
Messages: 4963
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?

Report message to a moderator

Re: Import Error [message #475660 is a reply to message #475563]

Thu, 16 September 2010 09:21

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.

Report message to a moderator

Re: Import Error [message #475667 is a reply to message #475660]

Thu, 16 September 2010 09:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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/

Report message to a moderator

Re: Import Error [message #475670 is a reply to message #475667]

Thu, 16 September 2010 09:55

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.

Report message to a moderator

Re: Import Error [message #475671 is a reply to message #475670]

Thu, 16 September 2010 09:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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?

Report message to a moderator

Previous Topic:	EXP, EXPDP, IMP & IMPDP
Next Topic:	Export Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 18:22:16 CDT 2024