Oracle Database link issues
Posted on 2015-02-02
I am trying to create a table from my database to a different database. but it isn't working. I created a database link which is talking to the database just fine. I am using the following code.
EXEC DBMS_UTILITY_EXEC_DDL_STATEMENT@MYDBLNK('CREATE TABLE MYTABLENAME AS (SELECT * FROM MY TABLE2)');
TABLE DOESN'T EXIST
and It has dba privileges... Any ideas on what i am doing wrong?