Question

oracle sql developer导出怎么打开

Answer 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！