Copying tables from one server.user to another.

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 9 Jul 2002 09:33:02 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70257059B@lnewton.leeds.lfs.co.uk>

Try using 'exp' on the machive you want to copy from and 'imp' on the machine you want to copy to.
See the Utilities guide for details on the parameters etc you will need.

HTH Regards,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: ganesh_at_valuesource.ws (V.Selva Ganesh) [mailto:ganesh_at_valuesource.ws]
Posted At: Tuesday, July 09, 2002 8:00 AM Posted To: server
Conversation: Copying tables from one server.user to another. Subject: Copying tables from one server.user to another.

Hi All,   

        I am a newbie to Oracle.I have a question on it.I have two Oracle Servers installed in different machines in the same network domain.Let us name it as Server1 and Server2.I have a user "Manager" in Server1 under whom there are some 100 tables.I want those tables to get copied to a different user in Server2.How shall I go about it? Im using Oracle 8 standard edition running on a Windows2000 Professional machine.
Any help shall be appreciated.

Thanks in advance,
SG. Received on Tue Jul 09 2002 - 03:33:02 CDT