Re: duplicating a database on a second server

If all you want to do is copy 1or 2 ( or a few, one at a time) tables, then you can create a Database link to the live server in your Dev one...

( See your docs for specifics on setting up a DB link) then, just

create table dev_table_name as select * from live_table_name_at_dblink_name_you_created

hth
Note- this will not replicate any constraints, privs, etc , it will just copy...

"Mohammed AL-Refaii" <a_refaii_at_hotmail.com> wrote:

>you have to do it by export and import
>
>
><ellisjb_at_my-deja.com> wrote in message news:87s3b6$he3$1_at_nnrp1.deja.com...
>> We have two Oracle servers, "live" and "development."
>> I need to copy a table from the live to the development one.
>> (Live is on Linux and Dev on NT, if it matters.) Can somone
>> point me to the right tool? If it's a choice between
>> copying the whole database over and copying nothing, I'll
>> do the former, but I'm hoping there's a way to just do
>> certain tables.
>>
>> Thanks,
>>
>> -Jonathan
>>
>>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.
>

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Thu Feb 10 2000 - 00:00:00 CST