Home » RDBMS Server » Backup & Recovery » IMP-00017 problem
IMP-00017 problem [message #239097] Mon, 21 May 2007 08:27 Go to next message
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.
Re: IMP-00017 problem [message #239103 is a reply to message #239097] Mon, 21 May 2007 08:55 Go to previous messageGo to next message
Frank Naude
Messages: 4502
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.
Re: IMP-00017 problem [message #239108 is a reply to message #239097] Mon, 21 May 2007 09:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: IMP-00017 problem [message #239171 is a reply to message #239108] Mon, 21 May 2007 12:00 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: IMP-00017 problem [message #239182 is a reply to message #239097] Mon, 21 May 2007 12:36 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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.
Re: IMP-00017 problem [message #239183 is a reply to message #239178] Mon, 21 May 2007 12:39 Go to previous messageGo to next message
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
Re: IMP-00017 problem [message #239189 is a reply to message #239182] Mon, 21 May 2007 13:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ana, ./fa/449/0/

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

Regards
Michel
Re: IMP-00017 problem [message #239208 is a reply to message #239183] Mon, 21 May 2007 14:14 Go to previous messageGo to next message
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
Re: IMP-00017 problem [message #239210 is a reply to message #239208] Mon, 21 May 2007 14:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Enlarge tablespace DATA.

Regards
Michel
Re: IMP-00017 problem [message #239215 is a reply to message #239210] Mon, 21 May 2007 14:57 Go to previous message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
thank u sir
Previous Topic: Plese suggest the solution for following test cases of recovery
Next Topic: User Managed Backups
Goto Forum:
  


Current Time: Sat Dec 03 01:14:57 CST 2016

Total time taken to generate the page: 0.13322 seconds