Home » RDBMS Server » Server Utilities » Export/Import across a network
Export/Import across a network [message #368380] Fri, 08 December 2000 11:11 Go to next message
meena
Messages: 36
Registered: December 2000
Member
Hi,

Can anyone tell me how to export and import a database across a network?? Thanks!!
Re: Export/Import across a network [message #368381 is a reply to message #368380] Fri, 08 December 2000 14:37 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi

You have to install the oracle client software in the client PC and using net8 assistant(part of oracle client software) tool create a service name for the database you want to exp/imp.

you have to give the database name(SID), the database server's ip address to create a service name.

now you all set to perform exp/imp on the database from you client pc via network...

from the dos promt you can issue
exp and imp commands.
Or if you have installed oracle enterprise manager tools(which is also part of oracle client software) in you client pc, you can use
'Schema manager' a GUI tool to do export and import which is much easier.

Go to http:\\technet.oracle.com and search for
export/import you have detailed documents out there................

Good Luck
Bala
Previous Topic: Re: Direct load using functions like NVL in the control file
Next Topic: max filesize for sql loader
Goto Forum:
  


Current Time: Sun Dec 05 09:14:35 CST 2021