Home » RDBMS Server » Server Utilities » IMP-00017: following statement failed with ORACLE error 1950 (linux, oracle 10.2.0.2)
IMP-00017: following statement failed with ORACLE error 1950 [message #505015] Thu, 28 April 2011 16:19 Go to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
While importing, I got the following error. How to resolve it?

IMP-00017: following statement failed with ORACLE error 1950:
CREATE TABLE "table_name".....
Re: IMP-00017: following statement failed with ORACLE error 1950 [message #505018 is a reply to message #505015] Thu, 28 April 2011 16:59 Go to previous messageGo to next message
ThomasG
Messages: 3099
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
oracle ~ $ oerr IMP 00017
00017, 00000, "following statement failed with ORACLE error %lu:"
// *Cause:  Import failed to execute the statement from the export file 
//          because of an Oracle error. 
// *Action: Look up the accompanying Oracle message in the ORA message 
//          chapters of this manual and take appropriate action.

 
oracle ~ $ oerr ORA 01950
01950, 00000, "no privileges on tablespace '%s'"
// *Cause:  User does not have privileges to allocate an extent in the
//          specified tablespace.
// *Action: Grant the user the appropriate system privileges or grant the user
//          space resource on the tablespace.
oracle ~ $ 

Re: IMP-00017: following statement failed with ORACLE error 1950 [message #505021 is a reply to message #505018] Thu, 28 April 2011 17:17 Go to previous message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
I STRONGLY suggest you push back from the keyboard & take some time to Read The Fine Manual.
http://download.oracle.com/docs/cd/E11882_01/server.112/e16508/toc.htm
& stop abusing this forum & expecting us to do error lookups for you.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

NEVER once have you followed Posting Guidelines!
Previous Topic: character set matching?
Next Topic: ORA-39125,ORA-31600 during expdp
Goto Forum:
  


Current Time: Sun Sep 21 23:23:10 CDT 2014

Total time taken to generate the page: 0.05841 seconds