导入(本机):
imp xtnygis/ecenter@orcl full=y file= C:\1.dmp ignore=y log=c:\img.log
导入(远程):
imp zjsnyt_gis/zjsnyt_gis@192.168.0.84/orcl file=c:\xtnygis.dmp log=c:\1.log full=y
导出带日期时间
exp hznbqlyg/hznbqlyg@192.168.0.88:1521/orcl file=c:\hznbqlyg%date:~0,10% %time:~0,8%.dmp
导出(远程):
exp hznbqlyg/hznbqlyg@192.168.0.88:1521/orcl file=c:\hznbqlyg20110107.dmp log=C:\aaa.log
imp xtnygis/ecenter@orcl full=y file= C:\1.dmp ignore=y log=c:\img.log
导入(远程):
imp zjsnyt_gis/zjsnyt_gis@192.168.0.84/orcl file=c:\xtnygis.dmp log=c:\1.log full=y
导出带日期时间
exp hznbqlyg/hznbqlyg@192.168.0.88:1521/orcl file=c:\hznbqlyg%date:~0,10% %time:~0,8%.dmp
导出(远程):
exp hznbqlyg/hznbqlyg@192.168.0.88:1521/orcl file=c:\hznbqlyg20110107.dmp log=C:\aaa.log