OraFAQ Forum: Backup & Recovery » IMP-00017 problem

Home » RDBMS Server » Backup & Recovery » IMP-00017 problem

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

IMP-00017 problem [message #239097]

Mon, 21 May 2007 08:27

vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY

Senior Member

Hello sir

we have import the datas from 8i server to new 9i server,the impot was not completed successfully it shows the following error.

IMP-00017: following statement failed with ORACLE error 942:
"CREATE UNIQUE INDEX "<name>" ON "<a_name>" ("<C_name>" ) PCTFREE 10 INITRANS"
" 2 MAXTRANS 255 STORAGE(INITIAL 655360 NEXT 524288 MINEXTENTS 1 MAXEXTENTS "
"4096 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLE"
"SPACE "DATA" LOGGING"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist

Plz help me
-Thanx.

Report message to a moderator

Re: IMP-00017 problem [message #239103 is a reply to message #239097]

Mon, 21 May 2007 08:55

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Oracle cannot create an index if the table doesn't exist. You need to find out why the table wasn't imported.

Report message to a moderator

Re: IMP-00017 problem [message #239108 is a reply to message #239097]

Mon, 21 May 2007 09:01

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

In addition, maybe it is a table you don't own in the original database.

Regards
Michel

Report message to a moderator

Re: IMP-00017 problem [message #239171 is a reply to message #239108]

Mon, 21 May 2007 12:00

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

ist check if table exits there then
you can also create index after table import just exclude it in imp command
like imp username/password file=... indexes=n

[Updated on: Mon, 21 May 2007 12:01]

Report message to a moderator

Re: IMP-00017 problem [message #239178 is a reply to message #239171]

Mon, 21 May 2007 12:28

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And why the index creation should work after the import if it does not succeeded during the import?

Your posts are really really inaccurate, irrelevant and useless.

Regards
Michel

Report message to a moderator

Re: IMP-00017 problem [message #239182 is a reply to message #239097]

Mon, 21 May 2007 12:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Michel,

You do not have to be politically correct here.
Please tell us how you really feel about DreamzZ.

BTW, I agree.

Report message to a moderator

Re: IMP-00017 problem [message #239183 is a reply to message #239178]

Mon, 21 May 2007 12:39

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Michel Cadot wrote on Mon, 21 May 2007 11:28

And why the index creation should work after the import if it does not succeeded during the import?

Your posts are really really inaccurate, irrelevant and useless.

Regards
Michel

Thanks uncle cadot

Report message to a moderator

Re: IMP-00017 problem [message #239189 is a reply to message #239182]

Mon, 21 May 2007 13:01

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Ana,

I have the reputation to always keep cool and temper my language.
I think sometimes I should keep even cooler. /forum/fa/1602/0/

Regards
Michel

Report message to a moderator

Re: IMP-00017 problem [message #239208 is a reply to message #239183]

Mon, 21 May 2007 14:14

vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY

Senior Member

thank u sir

Now it shows different following error.

IMP-00017: following statement failed with ORACLE error 1659:
"CREATE UNIQUE INDEX "<name>" ON "PROCEDURELOOKUP" ("CPTID" , "LOCID"
"" , "<nam1>" , "<nam2>" , "FORYEAR" ) PCTFREE 10 INITRANS 2 MAXTRANS 2"
"55 STORAGE(INITIAL 59375616 NEXT 524288 MINEXTENTS 1 MAXEXTENTS 4096 PCTINC"
"REASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "DATA"
"" LOGGING"
IMP-00003: ORACLE error 1659 encountered
ORA-01659: unable to allocate MINEXTENTS beyond 11 in tablespace DATA

-thanx sir

Report message to a moderator