oracle sql developer如何导入导出?

2025-03-27 17:53:27
推荐回答(1个)
回答1:

点击+打开数据库点击table,选中要导出的表,右键import date/export....
但是不建议这种方法,建议用dblink的方法,
create PUBLIC database link conn200
connect to loginname
identified by password
using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))';
然后insert into table_1 select * from table_1@dblink_conn200;
或者insert into dblink_conn200select * from table_1;
看你在哪边建dblink