exp/imp模块

来源:互联网 发布:张敬轩 知乎 编辑:程序博客网 时间:2024/06/10 10:24

备份表:



EXP  bi/bi@idc2  BUFFER=64000 FILE=E:\BACKUP\day_%date:~0,4%%date:~5,2%%date:~8,2%.DMP

log=E:\BACKUP\day_%date:~0,4%%date:~5,2%%date:~8,2%.log   TABLES=(AD_SID_DESCRIPTION)



备份元数据:


exp  sys/bi@idc2  owner=adrept  file=E:\BACKUP\progame_%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=E:\BACKUP\progame_%date:~0,4%%date:~5,2%%date:~8,2%.log  rows=N;


0 0
原创粉丝点击