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.