导出,用户的所有对象
owner:用户 grants:n无权限,y有权限 @BXJJG:为数据库名
exp bxrlzy/bxrlzy@BXJJG owner=bxrlzy file=d:/exp/bxrlzy_n.dmp grants=n log=d:/exp/log.txt
导入
full=y 导入所有
imp bxrlzy/bxrlzy@BXJJG file=d:/bxrlzy_n.dmp full=y log=d:/imp/log.txt
数据库连接配置:
BXJJG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.118.149)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)