日期:2014-05-17  浏览次数:21067 次

关于整个数据库导入的问题
想把一台旧数据库服务器中的数据库全部内容导入到新数据库服务器中的数据库中,
请问如何实现?

------解决方案--------------------
export from the old server:
exp "sys/pass@xxx as sysdba" full=y file=d:\full.dmp

copy the d:\full.dmp from the old server to the new server
then,import into the new server:
imp "sys/pass@xxx as sysdba" full=y file=d:\full.dmp

------解决方案--------------------
探讨
export from the old server:
exp  "sys/pass@xxx as sysdba"  full=y file=d:\full.dmp

copy the d:\full.dmp from the old server to the new server
then,import into the new server:
imp  "sys/pass@xxx as sysdba"  full=y file=d:\full.dmp