Friday, 13 September 2013

How to copy data from one database/table to another database/table in oracle using toad

How to copy data from one database/table to another database/table in
oracle using toad

I am trying to copy a table data from dev box db to uat db which are 2
different data bases . I am trying in toad.All the connection details are
correct but its not working and throwing the following error.
[Error] Execution (12: 1): ORA-00900: invalid SQL statement
This is what i am trying
copy from abc/cde@//abc.abc.com:1521/devbox to
abc/cde@//abc.abc.com/uatbox INSERT TOOL_SERVICE_MAPPING (*) USING (SELECT
* FROM TOOL_SERVICE_MAPPING)

No comments:

Post a Comment