DIRECT Default: n Specifies whether you use direct path or conventional path Export. Specifying DIRECT=y causes Export to extract data by reading the data directly, bypassing the SQL command-processing layer (evaluating buffer). This method can be much faster than a conventional path Export
关键字 说明(默认) ---------------------------------------- FULL 导入整个文件 (N)
怎样把%data%换成由其他页面传过来的参数吗?
imp system/manager file=c:\%data% full=y
Default: n Specifies whether you use direct path or conventional path Export. Specifying DIRECT=y causes Export to extract data by reading the data directly, bypassing the SQL command-processing layer (evaluating buffer). This method can be much faster than a conventional path Export
关键字 说明(默认)
----------------------------------------
FULL 导入整个文件 (N)
怎样把%data%换成由其他页面传过来的参数吗?
imp system/manager file=c:\%data% full=y
----------------------------------------------
你可以把传过来的参数设为环境变量,set data='',然后就可以用了
如:
把下面保存为:autobackallup.batif "%time:~0,1%"==" " (set backup_file=%date:~4,4%%date:~9,2%%date:~12,2%) else (set backup_file=%date:~4,4%%date:~9,2%%date:~12,2%) exp system/manager full=y inctype=incremental file=%backup_file%.dmp log=%backup_file%.log
exp system/manager@orac full=y direct=y file=c:\database.dmp