Home » RDBMS Server » Server Utilities » import error 00017,imp-00003 (oracle 10g,windowsserver2003)
import error 00017,imp-00003 [message #385198] Sat, 07 February 2009 06:27 Go to next message
esther242009
Messages: 2
Registered: February 2009
Location: india
Junior Member
hello
while trying to import a file from a user with same schema all the tables were imported and i had error while importing the packages.the errors were imp-00017,00003 and oracle error 1031.
thanks
esther
Re: import error 00017,imp-00003 [message #385201 is a reply to message #385198] Sat, 07 February 2009 09:52 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.

Re: import error 00017,imp-00003 [message #385205 is a reply to message #385198] Sat, 07 February 2009 10:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-01031: insufficient privileges
 *Cause: An attempt was made to change the current username or password
         without the appropriate privilege. This error also occurs if
         attempting to install a database without the necessary operating
         system privileges.
         When Trusted Oracle is configure in DBMS MAC, this error may occur
         if the user was granted the necessary privilege at a higher label
         than the current login.
 *Action: Ask the database administrator to perform the operation or grant
          the required privileges.
          For Trusted Oracle users getting this error although granted the
          the appropriate privilege at a higher label, ask the database
          administrator to regrant the privilege at the appropriate label.

Regards
Michel
Re: import error 00017,imp-00003 [message #385206 is a reply to message #385205] Sat, 07 February 2009 10:44 Go to previous messageGo to next message
esther242009
Messages: 2
Registered: February 2009
Location: india
Junior Member
thankyou
i am getting imp00017,ora-2304 errors when i checked the logfile of import.in export i did not get any problem.
i exported the schema from anotherdatabase version oracle10g.
regards
esther
Re: import error 00017,imp-00003 [message #385207 is a reply to message #385198] Sat, 07 February 2009 10:48 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you

I suspect you are trying to import into a version or Oracle which is older than the DB from which the export was taken.
Previous Topic: Command for sql*loader to merge columns' values into new column
Next Topic: Export -Import Speed up
Goto Forum:
  


Current Time: Fri Dec 09 15:19:40 CST 2016

Total time taken to generate the page: 0.11512 seconds