在项目小组开发中,需要连接同一个机器,小组共享一个数据库,怎么建立共享数据库,以下告诉你:
注:IP=连接目的机IP,tiger=数据实例名,TIGER=数据库名,DEDICATED=服务类型
# Method to connect with computer ip=10.4.52.123 # TIGER is DATABASE NAME # tiger is SERVICE_NAME or SID(check SID:select instance_name from v$instance) # SERVER = DEDICATED TIGER = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = tiger) (PRESENTATION = http://HRService) ) )
导入数据前创建一个用户wangchd:
create user wangchd identified by "wangchd";
grant resource to wangchd;
grant dba to wangchd;
grant connect to wangchd;
导出用户scott数据库:运行-->cmd,然后命令行输入以下代码,导出数据库到d盘
exp scott/tiger@WANGCHD file='d:\woker.dmp'
导入数据库到wangchd中:运行-->cmd,然后命令行输入以下代码,导入数据库worker为源数据库,wangchd目标数据库
imp wangchd/wangchd@WANGCHD file = 'd:\worker.dmp' fromuser = worker touser =wangchd
此方法可以导出sequence和每个表中的每个字段的所有数据,建议不使用PL/SQL直接导出**.sql