Re: Copying tables from one server.user to another.

1. Export from server1, and import to server2.
2. Create a database link, and do create table as select * from ...
3. Would get you indexes/constraints/grants/etc (if you so wish). 2) will only get data, and is probably a lot slower.

1)
exp userid=Manager/password_at_server1 owner=manager file=srv1man_20020716.dmp log=srv1man_20020716_exp.log

imp userid=Newuser/pass_at_server2 fromuser=manager touser=newuser file=srv1man_20020716.dmp log=srv2man_20020716_imp.log

If any of the objects already exist in the schema on server2 that you are importing stuff into, then you can specify ignore=y to ignore table creation errors.

In message <agebts$sf2$1_at_n2.peterstar.ru>, ed <ed_at_mail.ru> writes
>try to see command of SQL*Plus "COPY"
>"V.Selva Ganesh" <ganesh_at_valuesource.ws> wrote in message
>news:dc21bc98.0207082300.62add24f_at_posting.google.com...
>> 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.
>
>

-- 
Adrian Carlson-Hedges