Home » RDBMS Server » Server Utilities » Imp error: partial import of previous table rolled back (Linux)
Imp error: partial import of previous table rolled back [message #333648] Mon, 14 July 2008 01:08 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Imp error partial import of revious table rolled back [message #333759 is a reply to message #333658] Mon, 14 July 2008 06:50 Go to previous messageGo to next message
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?
Re: Imp error partial import of revious table rolled back [message #333805 is a reply to message #333759] Mon, 14 July 2008 08:36 Go to previous messageGo to next message
joy_division
Messages: 4640
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.
Re: Imp error partial import of revious table rolled back [message #333932 is a reply to message #333805] Mon, 14 July 2008 22:43 Go to previous message
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.
Previous Topic: sql loader question
Next Topic: Is it possible database backup tranfer to next version
Goto Forum:
  


Current Time: Sat Dec 03 18:23:40 CST 2016

Total time taken to generate the page: 0.08029 seconds