OraFAQ Forum: Server Utilities » Importing objects of another user

Home » RDBMS Server » Server Utilities » Importing objects of another user

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Importing objects of another user [message #177855]

Sat, 17 June 2006 01:32

shilpa.rajput
Messages: 31
Registered: May 2006
Location: Pune

Member

Hi all...
Here i've come up with a problem in importing data.I want to import some objects of a user into another user. For that i used the following syntax -

imp scott/tiger file=emp.dmp fromuser=scott touser=scott tables=dept
and even tried out for -

imp userid=system/manager fromuser=samrudhi touser=sini
file=mydmp.dmp

but its not working and throwing series of errors-

IMP-00058: ORACLE error 12560 encountered
ORA-12560: TNS:protocol adapter error
IMP-00000: Import terminated unsuccessfully

What could be the possible reason and solution for this?
Urgent reply will be appreciated...
Thanks in advance!

Report message to a moderator

Re: Importing objects of another user [message #177878 is a reply to message #177855]

Sat, 17 June 2006 06:03

harpreetsinghkup
Messages: 52
Registered: May 2006
Location: Mumbai

Member

PLease Check the proper syntax of Import COMMAND AND TRY AGAIN

Report message to a moderator

Re: Importing objects of another user [message #177901 is a reply to message #177878]

Sat, 17 June 2006 10:42

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Would it help if you, along with username and password, include the database this user lives in? Something like

> EXP scott/tiger@ora8_1 FILE=emp.dmp
> IMP scott@lion@ora8_2 FILE=emp.dmp

Report message to a moderator

Re: Importing objects of another user [message #178048 is a reply to message #177901]

Mon, 19 June 2006 04:34

shilpa.rajput
Messages: 31
Registered: May 2006
Location: Pune

Member

Thanks a lot...
It worked.
But one more thing would like to ask -the user holding the right of importing was 'sys' n after firing the command,i was asked to connect it as sysdba,but after spcifying connection as sysdba, i got the following error-

LRM-00112: multiple values not allowed for parameter 'userid'

Anyways,to solve the problem temporary,I gave full import grant to one of the users for some time. Imported the objects and again revoked the grant.
But would like to know how to import the objects by using 'sys' as userid.
Thanks in advance..

Report message to a moderator

Re: Importing objects of another user [message #178078 is a reply to message #178048]

Mon, 19 June 2006 06:07

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As you've said that only SYS can perform import, here's how you'd do that:

> EXP 'sys/its_password@database as sysdba' owner=scott file=scott.dmp

> IMP 'sys/its_password@database as sysdba' fromuser=scott touser=scott file=scott.dmp

Report message to a moderator

Previous Topic:	Export all objects in a user schema without data
Next Topic:	Import/Export

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 08:23:18 CST 2024