OraFAQ Forum: Server Utilities » Imp error: partial import of previous table rolled back

Home » RDBMS Server » Server Utilities » Imp error: partial import of previous table rolled back (Linux)

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

Imp error: partial import of previous table rolled back [message #333648]

Mon, 14 July 2008 01:08

altafhk
Messages: 45
Registered: June 2007
Location: Islamabad

Member

I want to import production dump of a user into testdb. I used to import many times but now I faced following:
import done in US7ASCII character set and AL16UTF16 character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing
IMP-00009: abnormal end of export fileSegmentation fault

I applied csscan, then tried import, found errors:
IMP-00009: abnormal end of export fileSegmentation fault
IMP-00028: partial import of previous table rolled back: 700488 rows rolled back
Import terminated successfully with warnings.

Can anybody help me to resolve this issue using exp/imp utility, I am using Oracle 10g ver 10.2.0.1

[EDITED by LF: fixed topic title; was "revious table"]

[Updated on: Mon, 14 July 2008 01:54] by Moderator

Report message to a moderator

Re: Imp error partial import of revious table rolled back [message #333658 is a reply to message #333648]

Mon, 14 July 2008 01:30

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Not enough information.
As you have a segmentation fault, you have a core dump.
I think you have to contact Oracle support for this.

Regards
Michel

Report message to a moderator

Re: Imp error partial import of revious table rolled back [message #333759 is a reply to message #333658]

Mon, 14 July 2008 06:50

altafhk
Messages: 45
Registered: June 2007
Location: Islamabad

Member

The problem solved.
It was scheduled export that was not done successfully. I copied the gzip file in testdb, then could not compare what size should be.
Again I took export and import required user successfully but when I dropped user cascade and create user with create session, resource grants, I found following error:
ORA-01920: user name 'XYZ' conflicts with another user or role name.
Please, describe?

Report message to a moderator

Re: Imp error partial import of revious table rolled back [message #333805 is a reply to message #333759]

Mon, 14 July 2008 08:36

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

01920, 00000, "user name '%s' conflicts with another user or role name"
// *Cause:  There is already a user or role with that name.
// *Action: Specify a different user name.

Report message to a moderator

Re: Imp error partial import of revious table rolled back [message #333932 is a reply to message #333805]

Mon, 14 July 2008 22:43

altafhk
Messages: 45
Registered: June 2007
Location: Islamabad

Member

No, I have create a new database and then created user testkhi, found error. Then I created user test and same error found.
ORA-01920: user name 'TEST' conflicts with another user or role name.
Anyways, thank you.

Report message to a moderator

Previous Topic:	sql loader question
Next Topic:	Is it possible database backup tranfer to next version

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 10:16:01 CST 2024