Home » Infrastructure » Other Operating Systems » how to do a copy of sqlpluq table.
how to do a copy of sqlpluq table. [message #101695] Tue, 26 March 2002 23:05 Go to next message
Dahbia
Messages: 1
Registered: March 2002
Junior Member
Dear all,
I would like to copy sqlplus table from my server which is working under openvms Operating system to work station PC.
the copy command is:
usage: COPY FROM db TO db opt table cols USING sel
db : database string, e.g., scott/tiger@d:chicago-mktg
opt : ONE of the keywords: APPEND, CREATE, INSERT or REPLACE
table: name of the destination table
cols : a comma-separated list of destination column aliases
sel : any valid SQL SELECT statement
can I have more details about this command and how to copy the table from the server to the PC?
Thank you in advance.
Re: how to do a copy of sqlpluq table. [message #101697 is a reply to message #101695] Tue, 02 April 2002 10:16 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
This is a copy from from PROD to DEV. I have both DEV and PROD alias' defined in tnsnames.ora on the target. I am connect to DEV (target).

SQL> copy from ghowell/PWD@prod create test using select * from test;

Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)
Table TEST created.

4 rows selected from ghowell@prod.
4 rows inserted into TEST.
4 rows committed into TEST at DEFAULT HOST connection.

SQL> drop table test;

Table dropped.

You could also use a database link. I am still on DEV:

SQL> create database link mylink connect to ghowell identified by PASSWORD using 'PROD';

Database link created.

SQL> create table test as select * from test@mylink;

Table created.

SQL> drop table test;

Table dropped.

SQL> drop database link mylink;

Database link dropped.
Previous Topic: Error in loggin
Next Topic: Re: Passing a9o9 parameter to a SQL*Form
Goto Forum:
  


Current Time: Fri Mar 29 04:19:23 CDT 2024