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
Note- this will not replicate any constraints, privs, etc , it will just copy...
>you have to do it by export and import
>> 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.
>> 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 ==-----