| how to do a copy of sqlpluq table. [message #101695] |
Tue, 26 March 2002 23:05  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
