Import [message #233200] |
Wed, 25 April 2007 03:22  |
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 #233204 is a reply to message #233202] |
Wed, 25 April 2007 03:34   |
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
|
|
|
|
|
|
|
|