This topic has been archived. It cannot be replied.
-
工作学习 / 学科技术讨论 / [Q] how to import a table using Oracle SQL DeveloperDoes any one know how to import a table from remote Oracle server database to local Oracle server database please?
The table does not exist in the local server.
Any advice is appreciated.
Thanks
C.W.
-carletonwong(自己修车);
2007-10-3
{206}
(#3970853@0)
-
用SQL PLUS的COPY指令COPY FROM remote_username/remote_password@remote_db TO local_username/local_password@local_db CREATE my_table USING SELECT * FROM my_table;
-newkid(newkid);
2007-10-4
{139}
(#3971350@0)
-
exp/imp(create database link first)
-ora600(ORA-00600);
2007-10-4
(#3973168@0)