Re: accessing tables on other boxes in queries

In SQL*Plus, you can use the COPY command. You'll have to have your connectivity set up properly though. Also, on several of my boxes, the COPY command has to be one long line - no continuation allowed.

You could also create a datbase link to do something like what you want. In this case, your command would look like: create table cat_orders as

   select * from orders_at_live_box

(The above depends on how you've set up the database link.)

hth,

mike

dsidvidvn wrote in message <3AB64B28.F2C56C24_at_btinternet.com>...
>I want to copy a table from the live box to cat.
>On the cat box can I use something like
>
>create table cat_orders as
>(select * from live_box.orders(username/password));
>
>Peter
Received on Mon Mar 19 2001 - 18:57:10 CST