OraFAQ Forum: Server Utilities » export from remote server

Home » RDBMS Server » Server Utilities » export from remote server

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

export from remote server [message #73261]

Wed, 10 March 2004 18:48

sunitha agarwal
Messages: 7
Registered: February 2004

Junior Member

how to make an export of particular user in remoteserver
i can able to connect thru sql but invoking whether we need sysdba privilege for it
can we export that specific schema then how to import it.

Report message to a moderator

Re: export from remote server [message #73263 is a reply to message #73261]

Thu, 11 March 2004 05:37

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

export / import are OS utilities.
You have to connect to the remote host using ssh or telnet or whatever....

Report message to a moderator

Re: export from remote server & import error [message #73265 is a reply to message #73263]

Thu, 11 March 2004 20:29

sunitha agarwal
Messages: 7
Registered: February 2004

Junior Member

i can connect to remote db using sqlplus
but i am not unable to export from that host how to do it.
i took export by logging system user another user but the export is done without any problem.How to import to an spceific user.I imported but its not comming to that system schema.how to import to specific schema.

Report message to a moderator

Re: export from remote server & import error [message #73273 is a reply to message #73265]

Mon, 15 March 2004 02:51

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>but i am not unable to export from that host how to do

from the local machine

exp dbaUser/password@remotedb owner=scott file=scott.dmp

>>how to import to an spceific user

imp dbaUser/pass file=scott.dmp fromuser=scott touser =scottsbrother

the objects are recreated in defualt tablespace of scottsbrother.
if the scottsbrother has resource role granted, he can write to any tablespace. therefore, if the source objects are in system tablespace , during import
the objects are created again in system tablespace.

Report message to a moderator

Re: export from remote server & import error [message #73276 is a reply to message #73273]

Mon, 15 March 2004 11:11

sunitha agarwal
Messages: 7
Registered: February 2004

Junior Member

hi thanks
i exported it 2 days before then
i had problems with import hope that it will fix it
sunitha

Report message to a moderator

Previous Topic:	How to load UTF16LE Data into ISO8859P1 Database
Next Topic:	ORA-01400 error when importing a dmp file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 19:39:38 CST 2024