Home > Mobile >  how i can use copy command in store procedure in oracle
how i can use copy command in store procedure in oracle

Time:09-29

i have a problem with this store procedure, send error when i use copy command

create or replace PROCEDURE COPY_PROCEDURE AS

   BEGIN

    COPY FROM USER/PASS@DB1 TO USER/PASS@DB2 REPLACE TABLE1 USING  select * from TABLE2;

   END;

CodePudding user response:

Copy command is niche facility supported by few oracle client tools. It is not integrated with oracle backend (RDBMS).

create table cloneA as select * from A@dblink

is much cleaner way to copy a table from one db instance to the other.

  • Related