Home » RDBMS Server » Server Administration » Import
Import [message #233200] Wed, 25 April 2007 03:22 Go to next message
kmkumar24
Messages: 69
Registered: January 2007
Location: Singapore
Member
Hi All,

I was taken the dump using export command from the tablespace level by creating par file from oracle9i. And i ftp the dmp file to my other server which is running on oracle10gR2.

While importing the parfile created the following error occured. Please help me to solve this problem.

$ imp parfile=imp_GC3.par userid=sys/glog@tmsdevdb

Import: Release 10.2.0.1.0 - Production on Wed Apr 25 16:15:04 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.


IMP-00058: ORACLE error 28009 encountered
ORA-28009: connection as SYS should be as SYSDBA or SYSOPERUsername: sys
Password:

IMP-00058: ORACLE error 28009 encountered
ORA-28009: connection as SYS should be as SYSDBA or

Thanks in advance

Magesh


Re: Import [message #233202 is a reply to message #233200] Wed, 25 April 2007 03:29 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

You need to add "as sysdba"

sys/password@db as sysdba
Re: Import [message #233204 is a reply to message #233202] Wed, 25 April 2007 03:34 Go to previous messageGo to next message
kmkumar24
Messages: 69
Registered: January 2007
Location: Singapore
Member
Hi Tahpush,

The following error occurs

$ imp parfile=imp_GC3.par userid=sys/glog@tmsdevdb as sysdba
LRM-00112: multiple values not allowed for parameter 'userid'

IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help
IMP-00000: Import terminated unsuccessfully


Thanks for reply

Magesh
Re: Import [message #233212 is a reply to message #233204] Wed, 25 April 2007 03:58 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

imp parfile=imp_GC3.par userid="sys/glog@tmsdevdb as sysdba"
Re: Import [message #233214 is a reply to message #233204] Wed, 25 April 2007 04:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
userid='sys/glog@tmsdevdb as sysdba'
You must quote the parameter value.

Regards
Michel

Re: Import [message #233215 is a reply to message #233214] Wed, 25 April 2007 04:02 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

echo
Re: Import [message #233221 is a reply to message #233215] Wed, 25 April 2007 04:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You're typing too fast for me. Wink
Re: Import [message #233336 is a reply to message #233221] Wed, 25 April 2007 13:49 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Laughing
Previous Topic: Localization settings
Next Topic: Oracle Error Msg
Goto Forum:
  


Current Time: Tue Dec 06 15:55:56 CST 2016

Total time taken to generate the page: 0.08160 seconds