你所谓导出指的是逻辑备份吧,如果是Oracle8i可以用: exp <user>/<password>@<service_name> file=<dmpname.dmp> 可以dblink查看操作其他数据库数据,建立方法: create database link <linkname> connect to <user> identified by <password> using <'service_name'> 使用: select * from test@linkname
dblink 是数据库服务器之间的链接。 CREATE PUBLIC DATABASE LINK mylink CONNNECT TO user IDENTIFIED BY password AUTHENTICATED BY user IDENTIFIED BY password USING 'connect_string';
exp <user>/<password>@<service_name> file=<dmpname.dmp> 可以dblink查看操作其他数据库数据,建立方法:
create database link <linkname> connect to <user> identified by <password> using
<'service_name'>
使用:
select * from test@linkname
通过net8配置访问服务名,在本机上执行命令:
exp userid=user/password/server full=y...不明白参数可以执行命令:
exp -?
CREATE PUBLIC DATABASE LINK mylink
CONNNECT TO user IDENTIFIED BY password
AUTHENTICATED BY user IDENTIFIED BY password
USING 'connect_string';