Re: [External] : sqlcl Copy

Hi,
me again

Charlotte

Look at this example below as a complementation (I made a mistake with the syntax in my before e-mail)

SQL> copy from
 /_at_(DESCRIPTION=(LOAD_BALANCE=OFF)(FAILOVER=ON)(CONNECT_TIMEOUT=10)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=source_host1))(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=source_host2)(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=source_host3)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SOURCEDB))) *TO* _at_DESTDB create test_table *USING* select * from dual;

On Thu, 23 Sept 2021 at 11:54, angelo <angelolistas_at_gmail.com> wrote:

> Hello,
>
> _at_Charlotte
>
> Could the TO parameter be missing ? Let´s analyze the error message and
> the syntax from the command.
>
> "A missing FROM or TO clause uses the current SQL*Plus connection"
>
> I think TO is mandatory, even if using a create table.
>
> "usage: COPY FROM <db> TO <db> <opt> <table> { (<cols>) } USING <sel>"
>
> again, it could be: COPY FROM _at_DB1 *TO* _at_db2 using create test_table select * from dual;
>
> In all your examples, the TO parameter is not there.
>
> " SQL> copy from /_at_(DESCRIPTION=(LOAD_BALANCE=OFF)(FAILOVER=ON)(CONNECT_TIMEOUT=10)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=source_host1))(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=source_host2)(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=source_host3)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SOURCEDB))) create test_table using select * from dual; "
>
> Maybe you can try it, obeying the syntax from "usage: COPY FROM <db> TO <db> <opt> <table> { (<cols>) } USING <sel>"
>
> SQL> copy from /_at_(DESCRIPTION=(LOAD_BALANCE=OFF)(FAILOVER=ON)(CONNECT_TIMEOUT=10)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=source_host1))(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=source_host2)(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=source_host3)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SOURCEDB))) *TO* _at_DESTDB (or @description whatever) *USING *create test_table using select * from dual;
>
>
> So, you can try it.
>
> regards,
>
> angelo
>
>
>
> On Thu, 23 Sept 2021 at 06:00, Charlotte Hammond <
> dmarc-noreply_at_freelists.org> wrote:
>
>> Thanks Jeff.
>>
>> I've tried both without success. Here's the commands and output I've
>> tried (same result both with and without the -oci flag):
>>
>> SQL> connect /_at_SOURCEDB <-- Checking passwordless connection with wallet to source
>> Connected.
>> SQL> connect /_at_DESTDB <-- Passwordless connection with wallet to dest
>> Connected.
>> SQL> copy from /_at_SOURCEDB create test_table using select * from dual;
>>
>> usage: COPY FROM <db> TO <db> <opt> <table> { (<cols>) } USING <sel>
>> <db> : database string, e.g., hr/your_password_at_d:chicago-mktg
>> <opt> : ONE of the keywords: APPEND, CREATE, INSERT, REPLACE,
>> APPEND_BYTE, CREATE_BYTE or REPLACE_BYTE
>> <table>: name of the destination table
>> <cols> : a comma-separated list of destination column aliases
>> <sel> : any valid SQL SELECT statement
>> A missing FROM or TO clause uses the current SQL*Plus connection.
>>
>>
>> or
>>
>> SQ> connect /_at_(DESCRIPTION=(LOAD_BALANCE=OFF)(FAILOVER=ON)(CONNECT_TIMEOUT=10)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=source_host1)(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=(HOST=source_host2)(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=(HOST=source_host3)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SOURCEDB)))
>> Connected.
>> SQL> connect /_at_(DESCRIPTION=(LOAD_BALANCE=OFF)(FAILOVER=ON)(CONNECT_TIMEOUT=10)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=dest_host1)(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=dest_host2)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=DESTDB)))
>> Connected.
>> SQL> copy from /_at_(DESCRIPTION=(LOAD_BALANCE=OFF)(FAILOVER=ON)(CONNECT_TIMEOUT=10)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=source_host1))(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=source_host2)(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=source_host3)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SOURCEDB))) create test_table using select * from dual;
>> usage: COPY FROM <db> TO <db> <opt> <table> { (<cols>) } USING <sel>
>> <db> : database string, e.g., hr/your_password_at_d:chicago-mktg
>> <opt> : ONE of the keywords: APPEND, CREATE, INSERT, REPLACE,
>> APPEND_BYTE, CREATE_BYTE or REPLACE_BYTE
>> <table>: name of the destination table
>> <cols> : a comma-separated list of destination column aliases
>> <sel> : any valid SQL SELECT statement
>> A missing FROM or TO clause uses the current SQL*Plus connection.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Thank You!
>> Charlotte
>>
>>
>>
>>
>> On Wednesday, September 22, 2021, 11:30:25 PM GMT+1, Jeff Smith <
>> jeff.d.smith_at_oracle.com> wrote:
>>
>>
>> I’m honestly not sure..in your copy command are you using a fully
>> qualified jdbc URL that contains all the necessary wallet info, or are you
>> relying on an OCI (thick) connection for an $ORACLE_HOME that already has
>> TLS configured?
>>
>> Jeff
>>
>>
>>
>> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
>> Behalf Of *Charlotte Hammond
>> *Sent:* Wednesday, September 22, 2021 6:12 PM
>> *To:* oracle-l_at_freelists.org
>> *Subject:* [External] : sqlcl Copy
>>
>>
>>
>> Hello Everyone,
>>
>>
>>
>> Just a quick question - is the Oracle wallet supported by the COPY
>> command in SQLcl? I can't get it to work but I'm not sure if it's not
>> supported or if I'm just doing something wrong.
>>
>>
>>
>> Thank You!
>>
>> Charlotte
>>
>

--
http://www.freelists.org/webpage/oracle-l